So Long and Thanks For All The Fish
Not to try and steal Satya Nadella’s thunder today at WPC but I’ve got some exciting news of my own...
2014-07-16
387 reads
Blog Posts
So Long and Thanks For All The Fish
Not to try and steal Satya Nadella’s thunder today at WPC but I’ve got some exciting news of my own to share. I’m excited to say that I’ll be...
2014-07-16
5 reads
Track Incomplete Statements
What about when statements are sitting in your server, uncompleted and not moving, just hogging resources? Use this script for...
2014-07-16
605 reads
Building the SQLSaturday Orlando Marketing Plan-Part 22
Had our second planning meeting, still trying to complete the email template and realized we had not clearly defined two...
2014-07-15
644 reads
PASS SQL Saturday Events: August 2014
DateEventAugust 2 SQLSaturday #324 – Baton Rouge 2014August 9 SQLSaturday #304 – Indianapolis 2014August 23 SQLSaturday #328 – Birmingham 2014August 23 SQLSaturday #309...
2014-07-15
648 reads
SQL Prompt – The Power Within
*Photo by Red Gate
Come a little closer; no seriously come on over just a little closer as I don’t want...
2014-07-15
572 reads
Understanding Analysis Services Relationships using Dimension Usage
As a part of designing an Analysis Services cube you must define how each dimension is related to each measure...
2014-07-15
1,725 reads
What does it mean that a value is NULL?
Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be...
2014-07-15 (first published: 2014-07-14)
10,906 reads
End of Mainstream Support for Microsoft SQL Server 2008 and 2008 R2
@DBA_ANDY: A reminder to all #sqlserver peeps out there and *especially* to our clients: #sql2008 #sql20008R2 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/09/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2.aspx#Ntirety
Original Message:
http://twitter.com/DBA_ANDY/status/488744595136999424
--
What does...
2014-07-14
10,345 reads
How to restore MSDB & MODEL database – SQL Server System Databases?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as...
2014-07-14
16,135 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