Start Your Engine’s with Startup Procedures
After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...
2017-08-21 (first published: 2017-07-31)
1,862 reads
Blog Posts
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL...
2017-08-21
135 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL Server also listed some resources you can use to...
2017-08-21
7 reads
Database Issue: The transaction log for database ‘db_name’ is full due to ‘ACTIVE_BACKUP_OR_RESTORE’.
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database was full. I logged onto the SQL server instance...
2017-08-20
7 reads
Database Issue: The transaction log for database ‘db_name’ is full due to ‘ACTIVE_BACKUP_OR_RESTORE’.
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database...
2017-08-20
491 reads
Query Store functionality in earlier versions of SQL Server
One of the best features introduced in SQL Server 2016 was the Query Store. Having the ability to see which...
2017-08-19
533 reads
31 Days of Disaster Recovery Revisited
A few years ago, I did a blog post series dedicated to disaster recovery (backups, restores, corruption, etc). 31 blog...
2017-08-18
472 reads
Being a Positive Influencer
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-08-18 (first published: 2017-07-31)
1,912 reads
Fixing You’ll need a new app to open this ms-word
It should come as no surprise that we rely heavily on SharePoint for sharing documents at Microsoft. For the most part it is a great solution with few issues....
2017-08-18
230 reads
Fixing You’ll need a new app to open this ms-word
It should come as no surprise that we rely heavily on SharePoint for sharing documents at Microsoft. For the most...
2017-08-18
886 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers