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
Superman
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
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
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
430 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 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
380 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
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers