What is a Non-Clustered Columnstore Index?
First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...
2014-04-29
5,624 reads
Team-based Database Development: Playing Nice With Others
Here are the slides and links to awesome resources for my presentation, “Team-based Database Development: Playing Nice With Others”
If you...
2014-04-29
2,666 reads
PowerShell-Input-Validation Scripts
Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...
2014-04-28
765 reads
PowerShell-Input-Validation Scripts
Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...
2014-04-28
2,012 reads
Sorkin On Writing
I saw this write up about Aaron Sorkin and the writing on Newsroom just after posting Blogging-Write More and found...
2014-04-28
643 reads
Last Weeks Top “Reading” Links #81
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-04-28
649 reads
[SQL Snacks Video] SQL Server Table Partitioning 103
Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two...
2014-04-28
939 reads
Why Can't I Reinitialize My Subscriber?
I recently had a colleague request help with a replication problem he was having with a client. The client was...
2014-04-28
3,370 reads
Video: Designing Stored Procedure Solutions
My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code!...
2014-04-28
1,238 reads
The default autogrowth settings do NOT come from the Model database.
I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed...
2014-04-28
1,160 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