T-SQL Tuesday #73 - Not Running CHECKDB is Naughty!
This month T-SQL Tuesday is hosted by Bradley Balls (blog/@SQLBalls) and his topic of choice is “Naughty or Nice.”
(If you...
2015-12-14 (first published: 2015-12-08)
2,859 reads
Nebraska SQL from @DBA_ANDY
What Do You Mean There is No Current Database Backup?!?
Yet another late night/early morning tale...
The LOG backups for multiple databases on a server failed overnight (not all databases, but...
2015-12-03
965 reads
We Are All Responsible
Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):
PASS Anti-Harassment Policy ReminderIt is unfortunate that I have...
2015-11-24
492 reads
CHECKDB - The database could not be exclusively locked to perform the operation
…so the job failed….again…you know the one – that darn Integrity Check job: Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete ...
2015-11-18 (first published: 2015-11-16)
11,339 reads
SQL Server Training
Brent Ozar’s group (http://www.brentozar.com/) just announced a pretty crazy set of “Black Friday” deals:
http://www.brentozar.com/archive/2015/11/announcing-our-2015-black-friday-sale-on-sql-server-training/
Insane sales if you can be one...
2015-11-12
580 reads
T-SQL Tuesday #72 - Implicit Conversion Problems
This month T-SQL Tuesday is hosted by Mickey Steuwe (blog/@SQLMickey) and her topic of choice is “Data Modeling Gone Wrong.”
(If...
2015-11-12 (first published: 2015-11-10)
1,863 reads
PASS Summit 2015 Recap
Last week was the annual PASS Summit in Seattle. The Summit is the predominant educational and networking event for SQL...
2015-11-03
606 reads
Deleting Files Older than X Hours with PowerShell
(aka "OMG I can't believe I am actually finally writing a #PowerShell blog post").
--
I currently have a situation at a...
2015-04-15
33,535 reads
Availability Groups - Where Did My Disks Go?
The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!
--At a client recently two availability groups on...
2015-04-02
12,945 reads
POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!
UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11...
2015-02-03
918 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