Expensive Enterprise Backup Tools – A survival guide
If you’re working for a big company, chances are that your IT already has a strategy and tools for dealing...
2017-09-13
980 reads
Blog Posts
Speaking at IT/DevConnections 2017
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...
2017-09-13
346 reads
Toolbox - IO, IO, Why are You So Slow?
This is the next in a series of blogs I am going to create talking about useful tools (mostly scripts)...
2017-09-13 (first published: 2017-09-06)
3,587 reads
What does this little check box do?
Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get...
2017-09-13
346 reads
#TSQL2sDay – Starting Out with PowerShell
This months TSQL2sday is hosted by me!
Surprise! – I chose PowerShell
I am really looking forward to seeing what other people post....
2017-09-12
595 reads
';SELECT *: How Unicode Homoglyphs Can Thwart Your Database Security
For the past couple weeks I've been writing about how to protect your database from a SQL injection attack. Today, we will keep the trend going by looking at how...
2017-09-12
60 reads
Automate Migrations–T-SQL Tuesday #94
It’s T-SQL Tuesday time again, and I’m slightly pressed for time, which is sad. This is a great topic.
Rob Sewell...
2017-09-12
416 reads
Creating Hyper-V VMs with Powershell
This month’s T-SQL Tuesday is hosted by Rob Sewell (b|t) and surprise, surprise, it focuses on Powershell so I thought...
2017-09-12
401 reads
Database Fundamentals #10: Modifying Tables
Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change...
2017-09-12
405 reads
Do I Need to Master PowerShell?
As a SQL Server DBA, do you need to be a master of PowerShell scripts? In this 9 minute episode, I talk about how much you need to know...
2017-09-12
21 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers