Backup and Restore Automation using SQLCMD and SQL Server agent
Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to...
2018-05-30
453 reads
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
369 reads
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
803 reads
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
455 reads
Importance of Statistics
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
603 reads
An interview with Brent Ozar
I was talking about interviews (although not the job kind) with a friend and it reminded me of the time...
2018-06-15 (first published: 2018-05-30)
2,936 reads
Azure SQL Database – The Default Isolation Is?
So what is the default isolation level for Azure SQL Database? I ran the following code to check it out....
2018-05-30
425 reads
SQL Server Minimally Logged Inserts (Assume Nothing!)
Side note :
I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
174 reads
SQL Server Minimally Logged Inserts (Assume Nothing!)
Side note : I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
149 reads
SQL Server: Backup and Restore operations using Cloud
This article discusses the concept of SQL Server backup and the various components required to use the Microsoft Azure Blob...
2018-05-29
397 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