Intro to Auditing in SQL Server on SQL Shack
I had an article published yesterday on http://www.SQLShack.com.
Intro to Auditing in SQL Server.
It’s worth reading if I do say...
2014-10-01
1,191 reads
SQLStudies
Database default locations
One of the options you had when installing your instance was setting some default file locations.
Defaut data file locationDefault log...
2014-10-01 (first published: 2014-09-29)
8,082 reads
What I know about batch files
For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how...
2014-09-24
616 reads
Changing configuration settings with sp_configure
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...
2014-09-24 (first published: 2014-09-22)
7,163 reads
Triggers are not toys!
For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL...
2014-09-17
1,437 reads
I SCHEMABOUND my scalar UDF and you won’t believe what happened next.
Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this...
2014-09-15
1,182 reads
What are trace flags?
Trace flags are one of those things that I’ve heard about more and more over the last five or six...
2014-09-18 (first published: 2014-09-11)
7,886 reads
T-SQL Tuesday #58: Passwords
It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host...
2014-09-12 (first published: 2014-09-09)
6,711 reads
Pausing an MSSQL Instance
I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop...
2014-09-04
3,739 reads
Two simple commands that can be a big help in performance tuning.
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...
2014-09-02
2,591 reads
Blogs
March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
SQL Saturday Atlanta BI Recap
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SQL 2017 server keeps locking up
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Alternatiives to Junk Dimensions
Hello SSC, I am not sure if I posted this in the right spot,...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers