Pointers For SQL Saturday Attendance
I recently got an email from another SQL Saturday organizer asking for "pointers for getting more attendees" to their upcoming...
2013-08-20
488 reads
SQL Tact
Cannot find NT Service\MSSQL$SQL2012?
If you cannot find the virtual account used by the default settings installation of your SQL 2012 instance (in this...
2013-08-16
1,184 reads
Distribution setup SQL Server Agent error: "RegCreateKeyEx() returned error 5, 'Access is denied.'"
In the Configure Distribution Wizard, the step "Configuring SQL Server Agent to start automatically" errors with the following text:
TITLE: Configure...
2013-08-15
11,589 reads
Baton Rouge Startup Weekend
I'm spreading the word out about an event this weekend called Startup Weekend.
It's an event for developers, designers, and entrepreneurs...
2013-08-13
619 reads
Recap from SQL Saturday Baton Rouge 2013
As the head of the planning committee for SQL Saturday Baton Rouge this year, I had the distinct pleasure of...
2013-08-04
794 reads
SQL Saturday Baton Rouge 2013
SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day...
2013-06-11
565 reads
SQL Saturday Baton Rouge Call for Speakers closes June 6!
SQL Saturday Baton Rouge Call for Speakers is open through June 6 (closes June 7 at midnight).
This year's pre-conference banquet...
2013-06-04
660 reads
Use the Default System Trace to Find Autogrowth Events
The SQL Server Management Studio built-in standard report for "Disk Usage" is very handy to view the performance-sucking autogrowth events...
2013-05-03
2,291 reads
Hunt Down Tables Without Clustered Indexes
This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...
2013-05-09 (first published: 2013-05-03)
2,558 reads
TRY_CONVERT broken by WITH SCHEMABINDING in SQL Server 2012 Data Tools build
Here's a bug you might find if attempting to schemabind an object that uses the new TRY_CONVERT function.
To reproduce, run...
2013-03-21
1,011 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