I am speaking at #sqlsat111 on TEMPDB.
I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend. I will be doing my session...
2012-04-13
560 reads
Tim Radney
SQLSAT107
I was recently selected to speak at SQL Saturday 107 in Houston TX. I am really excited to be selected...
2012-03-26
540 reads
SQL Skills IE3 #sqlskills
I attended my first SQL Skills event in December 2011. Due to a big project at work I was able...
2012-03-16
698 reads
Idera ACE Program
On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was...
2012-03-14
607 reads
SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able...
2012-03-14
616 reads
Find the version of the Master DB from a backup
Try researching recovering the master database online and you will see countless references to having to have SQL at the...
2012-01-25 (first published: 2012-01-20)
2,988 reads
SQL Server Login Auditing
In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed...
2012-01-05 (first published: 2012-01-03)
2,751 reads
Increase SQL Server Error Log Files
Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance...
2012-01-04 (first published: 2011-12-30)
3,943 reads
RedGate SQL Index Manager BETA
I recently attended the first micro training event with Red Gate where Grant Fritchey demonstrated a BETA tool called SQL...
2011-12-29
2,536 reads
First Blog Since the PASS Summit
The time following the PASS Summit has been absolutely crazy for me. Upon returning home I spent some much needed...
2011-12-08
540 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