SQL Homework – December 2018 – Configure SSMS
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...
2018-12-03
198 reads
Kenneth Fisher
Dealing with multiple AD accounts
To help promote the seperation of duties one of the things my company has done is to divide our permissions...
2018-11-29 (first published: 2018-11-19)
2,385 reads
Parameterized dynamic SQL is parameterized.
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic...
2018-11-23 (first published: 2018-11-15)
2,530 reads
The Cloud and Shadow IT.
Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck....
2018-11-21
937 reads
SQL Homework – November 2018 – Constraints
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed...
2018-11-14 (first published: 2018-11-05)
1,939 reads
T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a...
2018-11-13
227 reads
Zombie SQL
It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but...
2018-11-12 (first published: 2018-10-31)
2,896 reads
Missing those we’ve lost
It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to...
2018-11-07
223 reads
How do I look at my error log if SQL won’t open?
Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you...
2018-10-31 (first published: 2018-10-22)
2,624 reads
Blogger Questions: What if I get a mean/rude comment?
There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time...
2018-10-29
317 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