Last Backup Times per Database and Backup Type
This script displays the last date and time of each backup type for each database.
It’s useful when you need to...
2014-02-26
496 reads
Guy Glantser
How to Load Data from Excel in SSIS – 32-bit vs. 64-bit
Let's say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
3,650 reads
How to Load Data from Excel in SSIS – 32-bit vs. 64-bit
Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
1,172 reads
SSIS Appetizer
Madeira’s excellent course on SQL Server Integration Services starts in March, but you can get a head start here! Take...
2014-02-09
266 reads
Forty Things You Didn’t Know About SQL Server
Last week I delivered a seminar at the Expert Days 2013 event by the name of 40 Things You Didn’t...
2013-12-16
581 reads
PASS Summit 2013 – Day 5: SQL Server Internals Day
This is a summary of my last day in the PASS Summit. I have already written about my first, second,...
2013-10-19
409 reads
PASS Summit 2013 – Day 5: SQL Server Internals Day
This is a summary of my last day in the PASS Summit. I have already written about my first, second,...
2013-10-19
430 reads
PASS Summit 2013 – Day 4: SQLskills Day
This is my fourth day in the PASS Summit. I have already written about my first, second and third days.
The...
2013-10-18
468 reads
PASS Summit 2013 – Day 4: SQLskills Day
This is my fourth day in the PASS Summit. I have already written about my first, second and third days.
The...
2013-10-18
505 reads
PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell
This is actually the first formal day of the PASS Summit, but it's my third day here. I have already...
2013-10-17
559 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