Escaping from a runaway Logon trigger
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...
2014-05-27 (first published: 2014-05-19)
1,758 reads
Database Backup Encryption with SQL Server 2014
A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...
2014-05-26 (first published: 2014-05-19)
5,754 reads
PASS Business Analytics Conference 2014 Recap, part 2
These are my impressions from the PASS Business Analytics Conference 2014 in San José, California.
The first part of this series...
2014-05-19
339 reads
Building The SQLSaturday Orlando Marketing Plan–Part 8
One of things I wish PASS provided was at least one template for an event flyer, something that is basically...
2014-05-18
506 reads
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections are part of the Business Connectivity Services (BCS) that can be...
2014-05-18
1,262 reads
PASS Business Analytics Conference 2014 Recap, part 1
PASS Business Analytics Conference is not a new kid on the block anymore – happening for the second year in a...
2014-05-18
254 reads
Developer’s Life – Every Developer is a Spiderman
Originally posted on Journey to SQL Authority with Pinal Dave:
I have to admit, Spiderman is my favorite superhero. The most...
2014-05-17
784 reads
What Does it Cost to Implement a Business Intelligence Project?
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This...
2014-05-17
989 reads
The Tipping Point – by Malcolm Gladwell
The latest book that I finished reading was The Tipping Point, written by the Malcolm Gladwell. I would recommend this...
2014-05-16
186 reads
Reblog: May 9 to May 15
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-05-16
713 reads
Blogs
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...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers