DBA Myths: A table with a primary key is not a heap
Typically when you see a heading like this you know the answer is “No” or “False” but in this case...
2014-05-21
2,653 reads
Why Won't My Clustered Instance Start?
Last weekend I had a client page me in the middle of the night (because, of course, these things always...
2014-05-21
2,624 reads
Cumulative Update – 10 for SQL Server 2012 Service Pack 1 Is Now Available !
The 10th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-05-21
995 reads
Attaching All Databases with PowerShell – The Overview
TL;DR Script is here: Git Hub Powershell Scripts. It’s the attachdbs.ps1 and will attach all databases in a folder to...
2014-05-20
1,685 reads
Varchar "miracle" and best practice
I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...
2014-05-20
674 reads
Running Out of Foreign Keys-Question of the Day
Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you...
2014-05-20
344 reads
Presenting at ONETUG on July 10, 2014
I’ll be presenting SQL Performance for Developers to the members of ONETUG on July 10, 2014. I’m going to hit...
2014-05-20
415 reads
Comparison of Columnstore Compression
SQL Server 2012 introduced non-clustered columnstore indexes, and SQL Server 2014 gave us clustered columnstore indexes. Both share the same...
2014-05-20
1,852 reads
Tulsa User Group
I love user groups.
I have a special place in my heart for people who go out and give their time...
2014-05-20
633 reads
Google Analytics for SSIS (SQL Server Integration Services)
Update: There is a new 1.7 Version of Google Analytics Source for SSIS
In the modern age of the technology, almost...
2014-05-20
3,392 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers