What’s in a partition?
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...
2017-05-22
506 reads
Kenneth Fisher
Partitioning on a nullable column
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
2,062 reads
T-SQL FizzBuzz
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...
2017-05-17
2,865 reads
Why shouldn’t I shrink my database log file?
TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....
2017-05-15
480 reads
Simple Security Report
Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over...
2017-05-12 (first published: 2017-05-01)
2,276 reads
Dynamic SQL and the joys of QUOTENAME
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...
2017-05-11
606 reads
Continuous Integration
It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us...
2017-05-09
417 reads
Why is a Windows authenticated login more secure than a SQL authenticated one?
I had this question come up at work the other day and while I knew it was true I wasn’t...
2017-05-08 (first published: 2017-04-26)
3,770 reads
SSMS Tips: Copy Full Path
When you right click on a tab you’ll see a number of different options. You can set up new horizontal...
2017-04-24
382 reads
When should I add an index?
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we...
2017-04-21 (first published: 2017-04-19)
2,867 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers