Optimizing SQL Server Backup and Restore
When your databases grow, operations, like a database backup and restore, are going to take a longer time to complete....
2013-08-21
19,363 reads
Webcast Presentation Materials: Building Security Audits with Extended Events
Earlier today, I presented a session for Pragmatic WorksTraining on the T’s; which occur every Tuesday and Thursday. In the session,...
2013-08-21
1,030 reads
SQL Server Three Valued Logic and Ansi Nulls
SQL Server uses a three valued logic with True, False, and Unknown. And, normally, SQL Server Nulls are not comparable....
2013-08-21
1,297 reads
A placement firm’s “guaranteed” replacement
I have heard large placement firms say they are better than smaller firms because “They offer the client a guaranteed...
2013-08-20
625 reads
Trigger Status
Have you ever spent hours looking at an issue only to have your investigation hindered by a trigger? I know...
2013-08-20
1,174 reads
Data Purity issue after upgrading SQL 2000 to later versions
In SQL Server versions prior to 2005, it was possible to have invalid data values into a database. That can...
2013-08-20
927 reads
Pointers For SQL Saturday Attendance
I recently got an email from another SQL Saturday organizer asking for "pointers for getting more attendees" to their upcoming...
2013-08-20
500 reads
SQL Server – Why is the ‘sa’ Login Account Disabled & How to Enable ‘sa’ Login Account
Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason...
2013-08-20
747 reads
SQL Saturday 250 – Pittsburgh – Advice for My Presentation on Monitoring and Baselines
I’ll be presenting at SQL Saturday 250 in Pittsburgh on Baselining and Monitoring. This is my first public presentation, and...
2013-08-20
778 reads
SQL Server – Get SQL Server Service Account using T-SQL
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,506 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers