Database Has Been Paused
I was looking forward to do some work with Azure SQL Data Warehouse (DWH) when I hit the new query...
2018-04-03 (first published: 2018-03-27)
3,464 reads
Blog Posts
Date Fun with SQL Server
I saw a people discussing date formats on Twitter after PASS put out an advertisement for a webinar with a...
2018-04-03
398 reads
Power BI Custom Visuals Class (Module 96 – Enlighten Waffle Chart)
In this module you will learn how to use the Enlighten Waffle Chart. The Enlighten Waffle Chart is a simple...
2018-04-03 (first published: 2018-03-27)
2,550 reads
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...
2018-04-03
5 reads
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...
2018-04-03
11 reads
Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
289 reads
Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
53 reads
Remembering Robert Davis, aka @SQLSoldier
I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...
2018-04-03
40 reads
2018-04-03
259 reads
TDE – Regenerating the Database Encryption Key
As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...
2018-04-03
1,144 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers