SSMS 2016 Bug
I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to...
2016-10-27
644 reads
I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to...
2016-10-27
644 reads
I like row versioning– see this link for more details: https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx If your database is enabled for one of the...
2016-10-26
365 reads
This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt...
2016-10-25
465 reads
I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are...
2016-10-24 (first published: 2016-10-17)
1,963 reads
About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database...
2016-10-20
461 reads
The following DMVs shown within this blog post are some of the more common ones that I am finding really...
2016-10-18
475 reads
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
525 reads
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...
2016-10-11 (first published: 2016-09-27)
1,490 reads
I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...
2016-10-10
441 reads
SQL Server Performance Dashboards – update The first article that I ever wrote (http://www.sqlservercentral.com/articles/SQL+Server/127992/) was last year where I wanted to...
2016-10-07
619 reads
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers