Ken Wilson @_KenWilson

DBA for @IntlPaperCo, and @AlabamaFTBL fan #rolltide! https://t.co/YVpUczDILu SQL-Junction.com Memphis, TN Joined March 2012

Tweets

2K
Followers

164
Following

130
Likes

33

Ken Wilson @_KenWilson

3 years ago

Blogged for the first time in a very long time. sql-junction.com/2022/11/20/pas…

0 0 0 0 0

Ken Wilson @_KenWilson

3 years ago

Has anyone seen an issue with FILESTREAM access level runtime value reverting back to 0 after a reboot? This seems to be happening randomly in both 2014 and 2016. #sqlhelp

0 0 0 0 0

I have a Availability Group with 2016 FCI and and a 2016 async secondary replica. According to Microsoft docs the log stream compressed by default for async replicas but I’m not seeing any compression. Trace 1462 is not on. Thoughts? #sqlhelp

1 0 0 0 0

Ken Wilson @_KenWilson

4 years ago

Has anyone experienced an issue with a linked server only allowing 99 rows to return when using Oracle 19c client? If more than 99 rows are returned we get “unexpected catastrophic failure” message and a stack dump. The dump shows a memory access violation. #sqlhelp

0 1 0 0 0

Ken Wilson @_KenWilson

4 years ago

If TDE certs still work and can be used to restore the database if expired, why rotate them to keep them up-to-date? #sqlhelp

1 0 0 0 0

Ken Wilson @_KenWilson

5 years ago

Transaction log is 1.75 TB in simple recovery and you want me to add another log file? Hahahaha No!

0 0 0 0 0

Ken Wilson @_KenWilson

5 years ago

I have some SQL Server 2014 Express instances running on Windows 10 machines. Has anyone seen the 1909 upgrade cause the sa password to be cleared or reset? Just curious if it’s happened to anyone else. #slqhelp

0 0 0 0 0

Ken Wilson @_KenWilson

6 years ago

SQL version is 2014 build 12.0.6329.1 #sqlhelp

0 0 0 0 0

Ken Wilson @_KenWilson

6 years ago

Trying to delete data out of sys.syscolpars to fix metadata corruption as @PaulRandal blogged about but I’m getting ‘Ad hoc updates to system catalogs are not allowed’. #sqlhelp

0 0 0 0 0

Ken Wilson @_KenWilson

6 years ago

I backup the tail of the log on a database and the database is now in restoring mode. If I then attempt to restore and get an error that the mdf is in use. Is that something in the OS that is locking the mdf or could there be something in SQL Server? #sqlhelp

1 0 0 0 0

Ken Wilson @_KenWilson

7 years ago

Setting up AlwaysOn listener for an vendor application that uses four part naming in the queries. Several tables have xml columns so a linked server looping back on itself doesn’t seem to be an option. Any other options? #sqlhelp

1 0 0 0 0

Ken Wilson @_KenWilson

7 years ago

Can statistics cause data type conversation errors? #sqlhelp

3 0 1 0 0

Ken Wilson @_KenWilson

8 years ago

A user has created a database using db_creator. They are DBO but can’t access the database. Their application then created a user with the same login as DBO. Any thoughts on how this is possible? #sqlhelp

1 0 0 0 0

Ken Wilson @_KenWilson

8 years ago

The Windows SID is also incomplete as it is missing the last four digits. Any thoughts on how to track down what user this SID is tied to? 2/2 #sqlhelp

0 0 0 0 0

Ken Wilson @_KenWilson

8 years ago

Hello All, using sp_whoisactive I'm seeing connections that are displaying what looks to be a Windows SID instead of a friendly name. However, the database the login is connecting to has only SQL Server logins mapped to users. 1/2 #sqlhelp