Azure Stretch Database, Part I: Getting Going
With most innovative new technologies, Azure Stretch Database demos make it look completely easy. Here is a step by step to get going, with examples. Part One of a Two-Part series.
2019-08-26
4,948 reads
John F. Tamburo
Making Good Use of SQL Server Auditing
SQL Server Auditing is a powerful out-of-the box toolset that captures auditing information and writes to a file or the Event Log. This article examines the little things that might snag you up.
2019-08-05 (first published: 2017-10-05)
11,096 reads
DBAs and the ITIL Framework, Part II: Asset Management
See how the ITIL Framework's Asset Management standards make the DBA's job easier. Use the CMDB and DML to keep your data assets under tight control.
2019-05-17 (first published: 2017-11-21)
3,592 reads
Database Cloning Tools in Lower Environments
With exciting products like SQL Clone making their debut, the DBA will need to think through the approach to implementing such powerful tools. Done properly, these tools will provide a massive benefit to both the DBA and developer.
2019-05-10 (first published: 2017-11-28)
4,372 reads
Understanding Peer-to-Peer Transactional Replication, Part 3
We've gone through the basics of Peer-to-Peer Transactional Replication (PPTR). Now, we will blow it up! We will then fix it and show you how you how to triage and repair PPTR. When you remain calm and take some easy steps, you can stabilize PPTR with ease.
2019-01-04 (first published: 2016-01-07)
2,923 reads
SQL Authentication Via AD Groups Part II: Who has what access?
In a previous article, we discussed how to liberate the DBA from SQL Logins with AD Groups. A good point was raised: How can the DBA know who has what access? Here is a solution.
2018-08-03 (first published: 2016-02-18)
12,012 reads
Packaged-Application Database Nightmares - A Horror Story
The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?
2018-05-02 (first published: 2015-12-22)
5,432 reads
Random Word Generation for Data Scrubbing
With HIPAA and GDPR requiring your careful scrubbing of data for lower environments, random word generation promises to be a huge helper. Read here how to do it.
2018-05-01
5,832 reads
The DBA's Essential Index Monitoring and Maintenance Tasks
Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.
2018-03-09 (first published: 2016-02-15)
8,132 reads
Liberating the DBA from SQL Authentication with AD Groups
It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.
2018-02-02 (first published: 2015-12-21)
9,684 reads
Blogs
KDA: Echoes of Deception - Onboarding
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
Kusto Detective Agency - Intro
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
The Book of Redgate: Customer Quotes
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Forums
How to take a backup as a .bak file while omitting some tables?
Hi Guys, I'm not sure if this is possible or not, but let me...
Life Moves Pretty Fast
Comments posted to this topic are about the item Life Moves Pretty Fast
Parse XML data from SQL table using temp tables and variables
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Question of the Day
The Monitor Server
What does the monitor server do in log shipping?
See possible answers