How to install the tSQLt unit test framework to start unit testing your database code
This blog post describes how easy it is to install the tSQLt framework.
Don’t know much about tSQLt? If you are...
2018-12-29
515 reads
How to Cluster MaxDB on Windows in the Cloud #Azure #AWS #GCP #SAP
Recently I have had a number of customers looking for a high availability solution for MaxDB on Windows in the...
2018-12-28
464 reads
Shrinking Tempdb in SQL Server won’t work?
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly larger and I didn’t have much space on the...
2018-12-28
20 reads
Shrinking Tempdb in SQL Server won’t work?
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly...
2018-12-28
1,011 reads
Webcast: Data Modeling Scenarios and Best Practices
On January 17, 2019, I will be giving a webcast with MSSQLTips on data modeling best practices. It’s scheduled for...
2018-12-28
1,336 reads
Testing SQL in the Advent of Code
I like participating in the Advent of Code each year, though my participation often varies wildly as life gets in...
2019-01-09 (first published: 2018-12-28)
2,155 reads
Azure – Creating a storage account
Azure offers a lot of features that enable IT professionals to really enhance their environment. One feature that I really...
2019-01-08 (first published: 2018-12-28)
2,507 reads
SQL Servers Black Box Recorder – Def Trace
Very much like what you may find with the airline industry, the black box recorder in SQL Server is not just a single method (device) implemented to capture all of...
2018-12-28
18 reads
SQL Servers Black Box Recorder – Def Trace
Across many professions and industries there is often a need to have some sort of device that “audits” everything that...
2018-12-28
276 reads
Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC)
(last updated: 2019-01-08 @ 13:53 EST / 2019-01-08 @ 18:53 UTC )
There are times when I am working on a SQL script that...
2019-01-08 (first published: 2018-12-28)
5,134 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