Data Warehousing Explained
Why Warehouse
Data warehousing is the act of transforming application database into a format more suited for reporting and offloading it...
2017-05-14
256 reads
Gavin Draper
Using The SQL Server Merge Statement
Note : Since publishing this I’ve been notified that there are a number of outstanding issues with the SQL Server merge...
2017-05-08
56 reads
SQL Server Dynamic Pivot
Often when trying to pivot data you wont know what the possible values that you need to pivot on, in...
2017-05-07
59 reads
Using JSON In SQL Server 2016
The new JSON bits in SQL Server 2016 give you the ability to pull stuff out of JSON and to...
2017-05-06
89 reads
C#7 Show Me The New Stuff!
I’m going to walk through an example that we can build up and improve with a number of the new...
2017-05-05
32 reads
SQL Server Pivot and Unpivot Explained
The Pivot and Unpivot features in SQL Server are I find quite underused. For a long time I got by...
2017-05-04
49 reads
Why CROSS APPLY is AWESOME
CROSS APPLY was introducted as part of TSQL in SQL Server 2005. Origionally it was created as a way to...
2017-05-03
40 reads
Switch Your Site To HTTPS Using CloudFlare
SSL All the Things
Browsers are starting to highlight sites without SSL as insecure in a bid to push everyone to...
2017-04-26
128 reads
SQL 2016 Temporal Tables By Example
Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...
2016-04-15
74 reads
.Net CLI Cross Platform Awesomeness
.Net CLI is the new tooling that sits in front of .Net Core, allowing you to create and run projects...
2016-02-07
36 reads
Blogs
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Forums
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers