Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,397 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
170 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
1,016 reads
Privacy and Protection, By Design
With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on...
2018-04-11
450 reads
Free Webcast: DBA vs Memory Settings
Join me in two weeks for a really fun free webcast. Update: watch the recording of the webcast here! DBA vs Memory Settings Tues, April 24, 2018 – 8:30AM...
2018-04-11
12 reads
Understanding database recovery models in SQL Server
A recovery model is a database configuration option that determines the type of backup that one could perform and provides...
2018-04-11
781 reads
Baton Rouge SQL Server User Group – Execution Plans
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton Rouge .Net User Group does the same at the...
2018-04-11
14 reads
Baton Rouge SQL Server User Group – Execution Plans
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton...
2018-04-11
317 reads
Creating Facets in SQL Server 2017 Using R
SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do...
2018-04-11
963 reads
Using Elastic Query to Support SQL Spatial in Azure SQL DW
[read this post on Mr. Fox SQL blog] Recently we had a requirement to perform SQL Spatial functions on data that was stored in Azure SQL DW. Seems simple...
2018-04-10
18 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
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...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers