What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
447 reads
Blog Posts
Deploying a Windows Data Science Virtual Machine to Azure with PowerShell easily
This weekend (10 December 2016), I went to Slovenia for a SQL Saturday. As always, it was an amazing event...
2016-12-18
815 reads
SSRS 2016: Great and Getting Better
Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...
2016-12-18
411 reads
Saturday Reading 2016-12-17
It was my office Xmas party last night so whilst recovering on my settee, I’ll be reading:-
The Most Important Role...
2016-12-17
341 reads
SSIS Execution Status Lookup
The SSIS catalog comes packaged with a rich set of built-in reports that give those monitoring Integration Services a window...
2016-12-17
410 reads
Why I am called BlobEater
It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical...
2016-12-17
517 reads
Locking Resources in Azure
I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it...
2016-12-16
519 reads
Power BI on-Premises Production Targeted for Mid 2017
NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal. The production-ready release is targeted...
2016-12-16
439 reads
Reflecting on Ten Years of SQLSaturday
It’s hard to believe it’s been more than 10 years since we started the planning for the first event in...
2016-12-16 (first published: 2016-11-30)
1,161 reads
Unzip Files with SSIS
In my last post I shared how to build a package in SSIS to perform simple file archive (zip) operations....
2016-12-16
572 reads
Blogs
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
Check Power BI report interactions with Semantic Link Labs
It can be tedious to check what visual interactions have been configured in a...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers