Monday Morning SQL Break – January 18, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-01-25
419 reads
Blog Posts
Monday Morning SQL Break – January 25, 2016
It’s Monday and time for this week’s blog and twitter round-up. If you haven’t already, follow me on twitter (@StrateSQL)....
2016-01-25
388 reads
Public Speaking – The First Time
Update for T-SQL Tuesday #84
Well, this year I was challenged with the goal of speaking publicly three times, well I blew that out of the water and have spoken...
2016-01-25
4 reads
Public Speaking – The First Time
This past week I had the pleasure of speaking for my first time professionally to the Chicago Suburban SQL Server...
2016-01-25
503 reads
Querying Deadlocks From System_Health XEvent
It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is already capturing this information by default. This script will,...
2016-01-25
83 reads
Speaking at SQL Saturday #500 in Boston!
I have been selected to speak at SQL Saturday #500 in Boston on March 19th - I will be speaking (at...
2016-01-25
470 reads
SQL Server Statistics - Histograms
Most of us are aware of Statistics in SQL Server and its purpose. But still, just to get started, statistics...
2016-01-25 (first published: 2016-01-13)
3,209 reads
Things I learned in 2015
Happy 2016!
I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what...
2016-01-25
657 reads
CISL 1.1.0: cstore_doMaintenance (Columnstore Maintenace Solution Explained)
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
638 reads
Notes from SQLSaturday #480 in Nashville
Late posting, so reduced notes!
Speaker party was good. Room was loud when full due to wood walls and nothing to...
2016-01-22
625 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers