Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,379 reads
Blog Posts
Collation: Confusion
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-04-23
541 reads
FileTable–Adding a file to a folder
At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy...
2014-04-23 (first published: 2014-04-16)
3,636 reads
Learn High Availability and Disaster Recovery with SQL Server in a Day!
If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00...
2014-04-23
1,003 reads
MDX # 39 – Find Default Measure using MDX Query
In Chapter 1 of our book, MDX with SSAS 2012, we’ve devoted a section “Setting a default member of a...
2014-04-23 (first published: 2014-04-15)
3,121 reads
Practical Data Migration Strategies
Practical Data Migration Strategies
As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many...
2014-04-23
1,325 reads
SQL Server Partitioning 101
I’ve worked with partitioning for quite some time now, and though it has been around for quite some time and lots has been written about the concept I recently...
2014-04-23
10 reads
SQLSaturday #305 Dallas Business Analytics Edition
I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There...
2014-04-23
754 reads
SSMS Queries on Function Keys
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-23
1,074 reads
2014 SQL Server Editions – Overview
2014 is the latest edition of SQL Server available[/caption]
SQL Server 2014 was officially released in April 1st, 2014. You can...
2014-04-22
55,546 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