Speaking at SQLSaturday #635 in Vancouver this weekend
This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables,...
2017-08-23
125 reads
SQL Server vs Oracle: Substring
Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases...
2017-09-05 (first published: 2017-08-23)
7,230 reads
Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI....
2017-08-23
1,055 reads
VMworld 2017 SQL Server Sessions
Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill...
2017-08-23
131 reads
VMworld 2017 SQL Server Sessions
Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill...
2017-08-23
446 reads
Redgate Hub LiveStream
Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub....
2017-08-23
202 reads
Redgate Hub LiveStream
Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub....
2017-09-04 (first published: 2017-08-23)
861 reads
VLFs the Forgotten Foe
How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
Working as a consultant now,...
2017-09-07 (first published: 2017-08-23)
2,057 reads
Changing the version of an SSIS package.
Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say...
2017-09-06 (first published: 2017-08-23)
3,504 reads
The Wait Is Over – SSIS 2017 Is Here!
UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post...
2017-08-23
1,136 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers