Cost savings of the cloud

I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...

Creating Facets in SQL Server 2017 Using R

SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do...

Dates and Times in SQL Server: the science of time

Now that we have covered the various date and time data types (see the post from last time) in SQL...

DBA Fundamentals–Tuesday 11 Central–Execution Plans

WHAT:       EXECUTION PLANS FOR BEGINNERS
WHEN:       Tuesday,    04/17/18  - 11:00 am – 12:00 pm
WHO:         Thomas LeBlanc
WHERE:     https://attendee.gotowebinar.com/register/7086336336602188044
This will be a Beginners session highlighting...

Did you know…you can’t do arithmetic operations with datetime2 like with datetime?

I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I...

Free Webcast: DBA vs Memory Settings

Join me in two weeks for a really fun free webcast. Update: watch the recording of the webcast here! DBA vs Memory Settings Tues, April 24, 2018 – 8:30AM...

Privacy and Protection, By Design

With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on...

Professional and Proficient PowerShell: From Writing Scripts to Developing Solutions at PASS Summit

PASS Summit is the largest conference for technical professionals who leverage the Microsoft Data Platform. PASS Summit 2018 is happening November...

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2

(last updated: 2018-04-28)

Recap
In Part 1 of this 2 part series, I started with the loose definition in Microsoft’s documentation for...

Trekking Through Formatting Forest on the #SQLPrompt Treasure Map

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...