Want to be able to read your database between restores?
When restoring a database there are times when it would nice to restore a bit, check what’s been restored so...
2016-07-20
772 reads
Kenneth Fisher
Is the network your last performance bottleneck?
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options...
2016-07-18
439 reads
Altering a column in a large table: A case study
Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to...
2016-07-14
1,021 reads
Default database file sizes
It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing...
2016-07-12
752 reads
Finding, disabling and enabling foreign keys
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...
2016-07-11 (first published: 2016-06-29)
1,957 reads
Zilch to Speaker: 2016 Summit Abstract Reviews
Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along...
2016-07-07
446 reads
Perfectly Placed Parentheses
Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls etc....
2016-07-05 (first published: 2016-06-27)
2,837 reads
Phantom SSIS Changes
That SSIS change just won’t stick! There is a new business requirement, so now you have to change an existing...
2016-07-05
994 reads
Minimizing Cloud cost
The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working...
2016-06-27 (first published: 2016-06-20)
1,474 reads
Database snapshots
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating....
2016-06-22
509 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers