Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018 that Query Store was available in Public Preview for...
2019-03-12
13 reads
Blog Posts
Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018...
2019-03-12
380 reads
TSQL Tuesday #112 – Dipping into the Cookie Jar
This month’s TSQL Tuesday comes from Shane O’Neil and he’s asking us to ‘dip into the cookie jar’ (or raid...
2019-03-12
235 reads
T-SQL Tuesday #112 - The Cookie Jar
This month’s T-SQL Tuesday comes from Shane O’Neill (blog | twitter). He starts us off with this:
Dipping into the Cookie Jar is about when the going gets tough and...
2019-03-12
7 reads
T-SQL Tuesday Sharing Cookies
It has been a while since I have participated in a T-SQL Tuesday but I felt the urge to do...
2019-03-12
431 reads
Using Kubernetes Deployments for Updating SQL Server
In Kubernetes we can leverage Controllers to help manage our application state, keeping them in the desired state. In this blog post, we’re going to look at how to...
2019-03-12
4 reads
Data Warehouse Design and Power BI at SQL Saturday Tampa 2019
Hello, fellow data nerds! I wanted to make you aware of a fantastic event coming up this month in Tampa,...
2019-03-11
574 reads
2019-03-11
10 reads
Debugging Type Binding in PowerShell
Some effort I spent in researching Type Binding in Stack Overflow to help answer a question by Chris Oldwood helped me solidify my understanding of the best way to...
2019-03-11
7 reads
Enter our Database #DevOps Contest
Share your story and you could win. Enter as often as you like before Mar 20.
https://www.red-gate.com/hub/entrypage/competition
2019-03-11
378 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...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers