Powershell to Robocopy files (say, to back up your computer to protect against CryptoWall trojan)
We were having a good time on DBAs@Midnight, when Sean got a weird pop up message that said all his...
2015-02-07
1,130 reads
Blog Posts
Timed SQL Server tracing
Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...
2015-02-07
259 reads
2015 - the year of upgrade
2015 should be a very busy year for most DBAs, due to the end of support of SQL server 2005...
2015-02-06
331 reads
A quick email interview of Pass President Thomas LaRock
Back in December I had the thought that it would be fun to do an email interview with someone. As...
2015-02-06 (first published: 2015-01-28)
6,836 reads
Friday Followup For February 6, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-02-06
421 reads
2015-02-06
211 reads
SQL Server – Endpoint Authentication Error in AlwaysOn Availability Group Setup
According to MSDN: If the SQL Server service is running as a built-in account, such as Local System, Local Service,...
2015-02-06
642 reads
T-SQL Tuesday #62 - Wrap Up!
This month’s T-SQL
Tuesday #62, the first of 2015, hosted by yours truly, (invitation
to Healthy SQL here), asked that you all...
2015-02-06 (first published: 2015-01-29)
7,500 reads
Azure Enhancements – Time to take a look (and read the ebook.)
TweetG’day,
Recently I’ve become quite interested in the latest incarnation of Azure SQL Database.
For those that are unaware of some of...
2015-02-05 (first published: 2015-01-27)
6,544 reads
Enable SSDT and DacFx logging
**Update** I have noticed that these cmd files are missing from recent ssdt builds, to enable logging see Kevin’s comment:
http://blogs.msdn.com/b/ssdt/archive/2014/07/15/sql-server-data-tools-ju…
**/update...
2015-02-05
76 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