SSC Editorial: Lessons From Little Green Army Men
This one is about spending time with my daughter – she bought some army men as a toy after a visit...
2016-03-09
520 reads
Blog Posts
SSC Editorial: Spousal Surcharges
I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...
2016-03-09
478 reads
Tuga IT 2016 – Registrations are open
The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very...
2016-03-09
593 reads
VMware CPU Co-Stop and SQL Server Performance
Not too many people know about the intricacies of virtualization CPU scheduling and its impact on the performance of the VMs,...
2016-03-09 (first published: 2016-03-03)
1,264 reads
Announcing SQL Server on Linux
Yes, you read that right. SQL Server will be ported to Linux. Here’s the Blog post from Scott Guthrie.
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/
Today I’m...
2016-03-08
479 reads
Announcing SQL Server on Linux
Yes, you read that right. SQL Server will be ported to Linux. Here’s the Blog post from Scott Guthrie.
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/
Today I’m...
2016-03-08
147 reads
Converting SQL Backup Files to MTF
I got a copy of some backup files recently and needed to restore them. However, I don’t have SQL Backup...
2016-03-08
1,339 reads
Ever wonder what that goofy query in the header means?
It’s T-SQL Tuesday time again (Number 76!) and this month we are hosted by Bob Pusateri (b/t) who has invited...
2016-03-08
1,164 reads
Goodness-of-Fit Testing with SQL Server Part 6.1: The Shapiro-Wilk Test
By Steve Bolton
…………Just as a good garage mechanic will fill his or her Craftsman with tools designed to fix specific...
2016-03-08 (first published: 2016-02-29)
2,862 reads
My thoughts on SQL Server on Linux
Well yesterday was a big day in the SQL Community, Microsoft announced that they will be developing a version of SQL Server for Linux. Check out the announcement here.
Image...
2016-03-08
4 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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