SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either...
2011-03-23
1,511 reads
Jason Brimhall
SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either restarted or when the last time was that the...
2011-03-23
SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a...
2011-03-22
835 reads
SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a new system database was made available – the Resource...
2011-03-22
1 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue...
2011-03-21
1,364 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen...
2011-03-21
6 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple...
2011-03-18
599 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple of things that i hadn’t even considered. In thinking...
2011-03-18
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking....
2011-03-17
4,432 reads
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking. Those posts work well in conjunction with a post...
2011-03-17
Blogs
5 Advanced Online SQL DBA Training Courses to Learn in 2024 and Beyond
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
Dynamically Unpivot columns in SQL
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
Friday Basics: RPO and RTO
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
Forums
Azure SQL how to grant ALTER DATABASE permission
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
SQL Server Encrypt data into a file, send it and then decrypt
First off, my apologies for what could potentially be a bad title! I am...
Table partitioning best practice
I've inherited a couple of rather large databases from my ex-colleague when I join...
Question of the Day
Finding Marks
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers