T-SQL Tuesday #135 – Tools Used for Getting Organized
This month’s T-SQL Tuesday is being hosted by Mikey Bronowski. The subject he chose is “The outstanding tools of the trade that make your job awesome.” Tools are the...
2021-02-09
12 reads
What is a model database?
Do you ever take a look at SSMS in the System Databases section? People that are new to SQL Server might or might not know much about these essential...
2021-02-04 (first published: 2021-01-26)
577 reads
[MSSQLTIPS] Rookie of the Year Candidate – Vote for ME
Welcome to the New Year of 2021. For some people I know, they might prefer to forget most if not all of 2020. Personally, I am not one...
2021-01-04
13 reads
[PowerShell Newbie] Using Start-Transcript
This week we are going to launch a blog series geared towards folks that are new to PowerShell. The growing popularity of automation is seeing people getting started with...
2020-12-09 (first published: 2020-11-24)
425 reads
Export SQL Server Configurations for DR purposes
Is your SQL environment prepared for a disaster? There are big and small disasters and depending on your perspective big and small can mean different things. Preparing your environment...
2020-11-16 (first published: 2020-11-10)
634 reads
Blog Refresh – Growing Readers
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes of sharing new technology I was learning. The first post was as you could guess,...
2020-10-27
27 reads
How To: Create Schema Only Database Copies
Have you ever been asked to make a schema only copy of a database? What is your preferred method to complete this request? Below we will discuss how to...
2020-10-26 (first published: 2020-10-20)
1,405 reads
Copying an Azure SQL Database
Copying an Azure SQL Database is a vital skill when managing cloud databases. Recently, a request was received from the “business”. They wanted to create a copy of an...
2020-10-21 (first published: 2020-10-13)
273 reads
Checking your dumps!!!
No, No, not those dumps: SQL Server Memory dumps!! Recently, I was on Slack and wondered into the #firstresponderkit channel. I am a big fan of all the First...
2020-10-13 (first published: 2020-10-06)
668 reads
Failing SQL Agent Jobs – Part 4
Here we are, another Tuesday!! It is time for our Fourth and final installment in the Failing SQL Agent Jobs series. This week, we will cover how to store...
2020-10-06 (first published: 2020-09-29)
319 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers