MVP 2016!!!
Dear All,Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions to SQL Server Community in 2016!!!. This is an...
2017-01-22
10 reads
Blog Posts
Professional SSRS 2016 Book Preview Posts
This page is a table of contents for for several new and forthcoming posts. I’m posting a series of excerpts...
2017-01-22
505 reads
Adding Application Name to Invoke-SqlCmd2
In a previous post, I expressed some frustration over Invoke-SqlCmd not setting an Application Name for its ODBC connection, leaving us with the generic .NET SqlClient Library when looking at active sessions...
2017-01-20
47 reads
Easy Database Space with dbatools
One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is...
2017-01-20 (first published: 2017-01-06)
3,068 reads
Friday Reading 2017-01-20
Been an interesting week! My site has had the most views ever (so chuffed) and during all that I’ve been...
2017-01-20
516 reads
Implementing Fuzzy Sets in SQL Server, Part 7: The Significance of Fuzzy Stats
By Steve Bolton
…………In the world of fuzzy sets and imprecision modeling, the concept of cardinality takes on new shades of...
2017-01-20
500 reads
Installing dbatools on WS2012 R2
This is actually a simple, short post, but writing helps me remember things, and since I had to learn this,...
2017-01-20
908 reads
MVPs
I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program...
2017-01-20
658 reads
The most underrated show on Data Platform – SQL Unplugged
I would like to write a blog post about by far the most underrated online show about Data Platform – SQL...
2017-01-20
697 reads
The two types of IT worker
Last week I published this post about something a colleague noticed when playing around with a SQL Server instance running...
2017-01-20 (first published: 2017-01-17)
2,865 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...
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
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