SQL 2016 CTP 2.3 has been released
A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.
You can find the download here (the...
2015-09-01
846 reads
CONTEXT_INFO and efficient mass update on a large table with a trigger
Let`s assume we have following task – make changes to the data in a large table that has consistency checker in...
2015-09-01
751 reads
Experiences of Submitting a PASS Session
[read this post on Mr. Fox SQL blog] The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to...
2015-08-31
12 reads
Experiences of Submitting a PASS Session
[read this post on Mr. Fox SQL blog]
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in...
2015-08-31
946 reads
The most dangerous command in sql
GUYS,
I was just surfing internet to read more about GAM and SGAM. Accidently I read an awesome article about the...
2015-08-31
816 reads
The most dangerous command in sql
GUYS,
I was just surfing internet to read more about GAM and SGAM. Accidently I read an awesome article about the...
2015-08-31
2,791 reads
Upgrading a SQL Azure Database to v12
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-08-31
1,901 reads
Populating My DBA Database for Power Bi with PowerShell – Server Info
Following my last post about using Power Bi with my DBA Database I have been asked if I would share...
2015-09-09 (first published: 2015-08-31)
2,500 reads
SSC Editorial: The Problem Solver
The Problem Solver. Ever scoffed at personality types? Surely none of us are just one thing, but often we are...
2015-08-31
1,129 reads
The default instance has a name
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but...
2015-09-07 (first published: 2015-08-31)
3,279 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers