Start Your Engine’s with Startup Procedures
After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...
2017-07-31
387 reads
Start Your Engine’s with Startup Procedures
After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...
2017-08-21 (first published: 2017-07-31)
1,869 reads
Need to output CSV, TSV, or other?
Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017...
2017-07-31
416 reads
Twilight TimeZone: Handling Time in Your App Architecture at SQLSaturday Baton Rouge
Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern...
2017-07-31
658 reads
Backup Log to Nul– #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21 (first published: 2017-07-31)
1,730 reads
Being a Positive Influencer
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-07-31
354 reads
Being a Positive Influencer
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-08-18 (first published: 2017-07-31)
1,916 reads
Learning through gaming a SQL Server tale
I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience...
2017-08-18 (first published: 2017-07-31)
2,436 reads
DBA Dice
I’ve always thought it would be fun to have a DBA themed magic 8-ball. Now you may not be aware...
2017-07-31
584 reads
Video Tutorial: Creating a SQL Server Databases
In this Video tutorial we will look at creating a SQL Server database using both Management Studio and TSQL. We’ll...
2017-07-31
587 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers