Combating the CXPacket Wait Type
Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of...
2015-03-24 (first published: 2015-03-17)
7,449 reads
Adam Kreul | Blog
Making Sense of PCIe SSD Use with SQL Server
When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to...
2015-03-16 (first published: 2015-03-10)
6,036 reads
Configuring a Complete Memory Dump
Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform...
2014-11-06
1,934 reads
Database Maintenance Plans: A Primer
Databases and newborns have a lot in common. They both require constant care. They both require constant monitoring. They also...
2014-10-20 (first published: 2014-10-14)
7,033 reads
Why I’m Not Excited About Hekaton (In-Memory OLTP)
A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure...
2014-09-22 (first published: 2014-09-17)
8,448 reads
A CLR Application: Deleting Three Billion Rows
In one of SQL Server Central’s recent daily newsletters, Steve Jones’s editorial was inquiring whether or not anyone has been...
2014-03-06
1,170 reads
Fight Career Frustration With Learning
If you work in IT, the office becomes your second home. It’s where we make a living, and most of...
2014-03-11 (first published: 2014-02-28)
2,959 reads
I’m on Twitter! @AdamKreul
I’m just a little late to the party, but no time like the present, right? I plan to be very...
2014-02-15
638 reads
Make Your Storage Administrator Your Best Friend
That guy or gal over there going on and on about spindles and IOPS – that’s your SAN admin. For the...
2014-02-17 (first published: 2014-02-12)
1,630 reads
Configuring the RecycleTime SSRS Setting
If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading...
2013-11-07
4,444 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