Category: Uncategorized

Microsoft SQL Operations Studio

Today at PASS Summit Microsoft announced a new SQL “Tool” for running queries against SQL Server, called the Microsoft SQL Operations Studio. So what is the Microsoft SQL Operations Studio This appears to be a new cross platform (Mac, Linux,

Tagged with: ,

Script all Agent Jobs Using SQL Server Management Studio

While doing a recent server move, I came across the need to script all agent jobs and save them to a file so that if we needed to reference what was there after the move we could get at the

Tagged with: , , ,

My CheckDB Script

From time to time I get asked about checkDB, and there are many solutions out there, but I have one that I generally use that is very simple and does the job. The script below created a stored procedure in

Tagged with: , , , , , , ,

Podcast Episode 90: DBCC CheckDB

This weeks episode of the SQL Data Partners Podcast is Episode 90 released today.  Episode Quote “I would say that the bigger issue is probably going to be something like snapshot space for your disk” “When the rubber hits the

Tagged with: , , , , ,

TempDB – Do This and Don’t Do That

Today I had the opportunity to present on TempDB to the Spokane SQL Server users group (PASS Chapter). The session was titled TempDB – Do This and Don’t Do That”, and it covers a bunch of tips and best practices around

Tagged with: , , , , ,

Zero to SQL in 20 Lessons

My good friend and business partner Carlos L. Chacon has just completed an introduction to SQL book, that he has just published on Amazon. He is offering the Kindle edition for free for 2 days, December 14th and December 15th,

Tagged with: ,

Visualizing VLF’s – Updated

A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script. Here is an updated script that has adds another column called “TextStatus” to the

Tagged with: , , , , , , ,

SQL Data Partners – Podcast with Argenis Fernandez

In episode 53 of the SQL Data Partners podcast Carlos Chacon and I chat with Argenis Fernandez, storage guru and PASS Director-at-Large. We talk storage options, LUNs, IOPs, and why he thinks we all need to approach storage a lot differently.

Tagged with: , , , ,

SQL Data Partners – SQL Server Podcast

I am excited to announce that I have joined Carlos Chacon to become the co-host of the SQL Data Partners – SQL Server podcast. The weekly show has just reached 50 episodes, and Carlos has asked me to join him as co-host on

Tagged with: ,

RAID10 Saved The Day

Reliable DBA Services is one of the things I talk about on my business website at http://StedmanSolutions.com, but that can mean many things to different people. To me this has many meanings. Today the reliability of having RAID10 on my

Tagged with: , , , , , ,
Top