Why Separate Your Compute From Your Storage
There are many advantages to using Microsoft Azure. One big reason people look at Azure is the ability to separate...
2018-09-04
400 reads
Blog Posts
Azure SQL Database – Detecting Threats
At first I was nervous but then I realized it was me triggering “Someone has logged on to your server ...
2018-09-03
839 reads
Back to University, Redgate University
Let’s be really clear, Redgate makes ingeniously simple tools. That’s a fact. Nothing has changed. However, if you really want...
2018-09-03
281 reads
Calendar Reminders for SQL in the City Streamed Free Training Sessions
SQL in the City Streamed is coming up this week! This is an awesome FREE online event, and it’s all about learning new things and getting inspired. Join us...
2018-09-03
7 reads
CCI Bulk Load Pitfalls 1 – ETL Framework and up-to-date Statistics
Intro
I would like to start a miniseries of blogs where I try to summarize lessons learned from large data loading...
2018-09-03
76 reads
Installing External Modules into SQL Server’s Python
So Microsoft have integrated Python into SQL Server, from the moment I heard that I thought to myself, “wow, this...
2018-09-03
352 reads
NFL Football Player Stats & Analysis 2018 is now available!
I’ve had a lot of people ask me for this over the past few months and its finally (mostly) ready!...
2018-09-03 (first published: 2018-08-21)
2,552 reads
Oracle Atonomous
Last month Oracle – (Larry Ellison, CTO and Executive Chairman) has introduced Oracle Autonomous database for OLTP system Oracle has already...
2018-09-03
288 reads
SQL Homework – September 2018 – Backup and Restore continued.
In the very first SQL Homework post you were asked to take a backup. In fact it asked you to...
2018-09-03
804 reads
SQL in the City Summit
This fall, in October, Redgate Software will be hosting three, live, in-person events. These events will take place in New...
2018-09-03 (first published: 2018-08-21)
1,466 reads
Blogs
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...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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