The ‘In Recovery’ Mystery
Last week I received an email from one of our sysadmins asking why one of our databases kept showing as...
2016-03-31 (first published: 2016-03-22)
1,646 reads
The Database Avenger
SSRS 2016 – Part 3 Mobile Reports
This is the final post of 3 on SSRS 2016. This time I’m looking at the new SSRS 2016 mobile reports.
Post 1 covered...
2016-03-14
6,267 reads
No Joke, SQL Server on Linux
Yesterday Microsoft made the earth shattering news that a version of SQL Server with the “core relational database capabilities” will be...
2016-03-08
411 reads
SWITCHing IDENTITY in the Pub
I was recently talking to a friend in our local pub about a problem he had with tables not using IDENTITY...
2016-03-01
642 reads
DBCC Just Runs Faster, Unless You’re Cheap
The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales...
2016-02-25
602 reads
SSRS 2016 – Part 2 New Features for Paginated Reports
This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the...
2016-02-22
1,119 reads
Importing Open Data Sets in SQL Server
Whilst working on an upcoming post I realised that I needed a decent data set on which to test some...
2016-02-15
679 reads
SQL Server Reporting Services 2016 – Part 1
This first post of 3 takes a quick peek at SSRS 2016 using the Community Technical Preview (CTP) 3.2. I...
2016-02-03
1,328 reads
SQL Server Management Studio Setup and Configuration
This is my first #entrylevel blog post. The challenge identified by the tags #entrylevel and #Iwanttoshare was started by Tim...
2016-01-28
1,128 reads
Installing SQL Server 2016 Community Technology Preview
This post is designed to explain the installation steps of some of the new features in 2016 and just how...
2016-01-20
748 reads
Blogs
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Forums
Pivot Help
Hi Guys I need help pivoting the following SELECT [ID],[code_name],,[retail_price] FROM products 1 |...
Writer methods in PowerQuery (LOL)
I'm using PowerQuery in Excel on my desktop. (Yeah, I know you can do...
Need help with GROUP BY...
Here's my data... I am trying to return total days in status for each...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers