Restoring a database that doesn't exist
When restoring a database that doesn't exist, say for instance when a client sends a database to you, you can't...
2015-04-28
2,305 reads
Blog Posts
T-SQL Tuesday #65 – Learning Computed Columns for XML
It’s T-SQL Tuesday time again, and this month the invite comes from Mike Donnelly (@sqlmd). The topic is Teach Something...
2015-04-28 (first published: 2015-04-14)
5,900 reads
Use PsPing When Working in Azure IaaS
Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best...
2015-04-28
1,071 reads
Windows Temporary Profile
Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc...
2015-04-28
797 reads
Approaches to deploying Sql Server database code
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare & deploy” way.
Manual The manual way is where you...
2015-04-27
6 reads
Approaches to deploying Sql Server database code
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare...
2015-04-27
69 reads
Approaches to deploying Sql Server database code
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare...
2015-04-27
586 reads
Approaches to deploying Sql Server database code
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare...
2015-04-27
60 reads
Benefits for Some, All or Only a Few
As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can...
2015-04-27
512 reads
BIML is better even for simple packages
BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at...
2015-04-27
6 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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 ...
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...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
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...
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