dbatools at #SQLSatDublin
This weekend SQL Saturday Dublin occurred. For those that don’t know SQL Saturdays are free conferences with local and international speakers...
2017-06-21
915 reads
How to use Python in SQL Server 2017 to obtain advanced data analytics
On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest...
2017-06-20
788 reads
SQLpassion Online Trainings in July 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-06-20
180 reads
5 Business Problems You Can Solve With Temporal Tables
Watch this week's video on YouTube
It's 4:30 pm on Friday and Mr. Manager comes along to tell you that he needs you to run some important ad-hoc analysis for...
2017-06-20
31 reads
Speaking at the Data Platform Summit 2017
I am honored to be speaking at the Data Platform Summit 2017. The event takes place August 17-19, 2017 in...
2017-06-20
562 reads
Power BI Custom Visuals Class (Module 56 – Rotating Tile)
In this module you will learn how to use the Rotating Tile Custom Visual. The Rotating Tile gives you the...
2017-06-20
718 reads
Database Fundamentals #3: What’s In a Database?
It’s worth noting that a lot of people will never need to create their own database. You may never create...
2017-06-20
494 reads
Statistics and Cardinality Estimation
Cardinality
This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”....
2017-06-30 (first published: 2017-06-20)
5,869 reads
SQL Server 2017 Concatenation With STRING_AGG
One of the new less publicized features in SQL Server 2017 is STRING_AGG. This new feature can take an expression...
2017-06-20
96 reads
How the Initial VLF sequence number gets decided of the default transaction log file
In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...
2017-06-28 (first published: 2017-06-20)
1,582 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
SQL Server Automated Backup & SAN Replication Solution
Comments posted to this topic are about the item SQL Server Automated Backup &...
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers