Azure Data Warehouse and 60 Servers
In today’s segment of Azure Every Day, I’d like to talk about Azure Data Warehouse and to help you understand...
2018-09-07
653 reads
Blog Posts
Best Way to Fix Corrupted SQLite Database
Corruption is one of the common scenarios nowadays. It can occur in any platform or file format, for that matter. Similarly, Android SQLite database can be corrupted due to...
2018-09-07
25 reads
Best Way to Fix Corrupted SQLite Database
Corruption is one of the common scenarios nowadays. It can occur in any platform or file format, for that matter....
2018-09-07
1,565 reads
External Access to Azure Storage
There are multiple ways to allow external access to Azure storage accounts, some better (and more secure) than others. Today,...
2018-09-07
340 reads
FizzBuzz and Multiple Recursive Member CTEs
Watch this week’s episode on YouTube.
Last week I needed to write a recursive common table expression. I’ve written them before,...
2018-09-07 (first published: 2018-08-21)
2,340 reads
I will be speaking at SQL Saturday # 788 – Denver
I’m very thrilled to announce that I will be participating as speaker in Denver’s SQL Saturday that will take place on...
2018-09-07
308 reads
Rant: There Is No NoSQL Data Storage Engine
Do I need relational or NoSQL? How does NoSQL help me scale? Will I get paid better with NoSQL or...
2018-09-07 (first published: 2018-08-15)
2,862 reads
Watch My Keynote: Adapt and Thrive (25 minutes)
Do you know where your career is going? Do you know what skills you need to be successful in the current climate? In this 25 minute keynote, I discuss the...
2018-09-07
4 reads
#SQLCareer 3/4 August 6th 2018
Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database...
2018-09-06 (first published: 2018-08-22)
1,656 reads
Be in the SQL Yearbook
I’ve been thinking about this for years, and I’m finally doing it. I’m making a SQL Yearbook, and I want you to be...
2018-09-06
266 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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