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,017 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
383 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
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