Locking sa
When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the...
2016-04-04
1,049 reads
Blog Posts
Monday Morning SQL Break – April 4, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-04-04
462 reads
MongoDB – Calculating Document Size
We can get the size of a document is by using the shell’s Object.bsonsize() function.We pass the object_id of the document...
2016-04-04
539 reads
SSC Editorial: Is Powershell Intimidating?
Is Powershell intimidating? It’s an interesting question, though perhaps unfair – TSQL can be intimidating when you first start out too....
2016-04-04
528 reads
The OUPUT Clause in an INSERT–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-04-04 (first published: 2016-03-23)
3,224 reads
Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-04
219 reads
When a calculated measure is added NON EMPTY stopped working
We use NON EMPTY key word on the rows axis to remove rows with NULL values. It works only when all...
2016-04-04 (first published: 2016-03-24)
2,470 reads
How to Load XML Data Files using the SSIS Script Component.
One of the common source data files that every ETL Developer/Architect will have to grapple with every now and then...
2016-04-03
17,848 reads
Reporting Services 2016 – Back in the game: the new capabilities & features // Zurück im Spiel: die neuen Möglichkeiten und Features
(DE)
Meine letzten Veröffentlichungen und Vorträge zu Reporting Services sind schon Jahre her. Kein Wunder, denn seit dem 2008 R2-Release...
2016-04-03
877 reads
Speaking at SQL Saturday #487 in Ottawa on April 16, 2016
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-03
473 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I