Introducing Managed Backups in SQL Server 2014
Some of the new functionality of 2014 is straight forward, non-controversial and easily welcomed by the community. Think, updateable column...
2013-12-17
2,347 reads
The Scary DBA
SQL Server 2014 Backup to URL
I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location....
2013-12-11
1,719 reads
Speaker of the Month, December 2013
This will be my fifth speaker of the month post. Do a search to see the others.
I try to find...
2013-12-06
619 reads
Windows Azure Views
It’s kind of fun to see Azure development artifacts on display. I’ve posted about them before, a couple of times....
2013-11-19
875 reads
Cargo Cult Data Professionals
Ever since David Moutray introduced me to the concept of cargo cult programming, it’s been running round and round in...
2013-11-12
978 reads
For the Aspiring DBA
Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...
2013-11-18 (first published: 2013-11-11)
1,483 reads
More Azure Goodies
Microsoft keeps sneaking little things under the door for Windows Azure SQL Database. This time it’s a couple of new...
2013-11-12 (first published: 2013-11-05)
1,781 reads
Speaker of the Month, November 2013
Yeah, I’m a couple of days late. Tough. My blog. My rules.
Speaking of rules. Speaker of the Month is chosen...
2013-11-04
652 reads
Query Tuning in Dallas
Let’s have some fun.
This Friday, November 1, 2013, I’m putting on an all day seminar on query tuning. It’s set...
2013-10-29
675 reads
SQL in the City, US Tour 2013, Recap
Red Gate visited three cities this year with our SQL in the City event; Pasadena, Atlanta and Charlotte. I just...
2013-10-22
837 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers