Last Weeks Top “Reading” Links #69
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-03
1,087 reads
Blog Posts
Negative session_ids
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right?...
2014-02-03 (first published: 2014-01-27)
2,171 reads
Powershell in a Month Day 15 – Jobs
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-02-03
631 reads
Renaming The Reporting Services TempDB Database
Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to...
2014-02-03
1,343 reads
SSIS – Using Kill with SP_Who to Break locks
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...
2014-02-03
1,681 reads
SSIS – Using Kill with SP_Who to Break locks
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...
2014-02-03
411 reads
Verdasys Digital Guardian and SQL Server
I’m writing this post as a reminder for myself and possibly to help out the poor souls that may suffer...
2014-02-03
1,015 reads
What Tables Are In My Filegroups
One issue I've found a bit troublesome is trying to find out what's in a specific Filegroup. Let's say you're...
2014-02-03
382 reads
Analyzing your Microsoft Exchange Account Data with Power Query
One of the interesting additions to the Power Query Preview December update is the ability to import data from Microsoft...
2014-02-02
488 reads
Hortonworks Makes HDP 2.0 for Windows Server Generally Available
Today, Hortonworks announced the general availability of the Hortonworks Data Platform (HDP) 2.0 for Windows. This is the next release...
2014-02-02
328 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