My SQL logins don’t work. Again.
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one...
2017-02-02 (first published: 2017-01-25)
2,387 reads
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one...
2017-02-02 (first published: 2017-01-25)
2,387 reads
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...
2017-02-01
737 reads
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...
2017-01-30
668 reads
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...
2017-01-30 (first published: 2017-01-23)
1,115 reads
You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up...
2017-01-19 (first published: 2017-01-16)
2,512 reads
Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and...
2017-01-18
2,461 reads
I’ve been studying Azure recently and came across a really interesting Azure site.
resources.azure.com
To give you an idea why I find...
2017-01-13 (first published: 2017-01-05)
1,453 reads
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...
2017-01-12
811 reads
I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the...
2017-01-10
460 reads
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found...
2016-12-28
1,511 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers