MySQL has this feature that SQL Server needs
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because...
2017-11-22
342 reads
Born SQL with Randolph West
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both...
2017-11-15
569 reads
T-SQL Tuesday: The Contributing Factor
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two...
2017-11-14
322 reads
Is Transparent Data Encryption just security theatre?
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
330 reads
Gimmicks that work: XE Profiler in SQL Server Management Studio
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
492 reads
Repair a Windows Server 2016 installation
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
4,275 reads
The perils of RAID
Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...
2017-10-18
620 reads
Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to...
2017-10-11
456 reads
Changes to Service Packs and Cumulative Updates for SQL Server 2017
For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update...
2017-10-04
441 reads
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
542 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers