Third Party Backup Tools – Redgate SQL Backup
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,899 reads
Gethyn Ellis
T-SQL Tuesday #005 – Offloading Reporting (#TSQL2sDay)
Aaron Nelson (Blog|@SQLvariant) is hosting this months #TSQL2sDay with the theme of reporting. My post looks at some of things...
2010-04-13
666 reads
db_executor role
This process might not be granular enough for some but there is a nice simple way of creating a role...
2010-04-12
34,124 reads
Q1 - review
I didn’t post my professional goals for the year on my blog at the start of this year, my blog...
2010-04-08
670 reads
Uninstall 64 bit and reinstall 32 bit SQL Server
For reason's beyond the scope of this post I needed to uninstall a 64 bit version of SQL server standard...
2010-04-06
2,455 reads
Differential Backups
My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log...
2010-04-04
1,292 reads
Powershell – Useful Resources
One of my aims at the start of the year was to improve my Powershell and scripting skills. I run...
2010-04-01
1,130 reads
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-31
1,271 reads
SP_change_users_login and SQL Server 2008 onwards
Today I discovered, from a post on the forums and a follow up dig into BOL that sp_change_users_login is to...
2010-03-30
5,802 reads
Scheduling backups in SQL Server Express
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always...
2010-03-29
1,699 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers