One SSMS Trick That Will Make You a Faster Query Builder
Watch this week's video on YouTube
Here's the scenario: you copy and paste some code into a query you are building. A few minutes later you need that same snippet...
2017-07-25
11 reads
Blog Posts
SQL Server Management Studio: Video Tutorial
SQL Server Management Studio is the all in one tool for developers and DBAs alike to work with SQL Server....
2017-07-25
465 reads
SSoL: Where are my data and log files?
I don’t think most of us need to know Linux, but if you end up managing a system, it’s good...
2017-07-25
712 reads
Streaming ETL: SQL Change Data Capture (CDC) to Azure Event Hub
[read this post on Mr. Fox SQL blog]
I had a recent requirement to capture and streamreal-time data changes on several SQL database...
2017-07-25 (first published: 2017-07-11)
11,236 reads
Announcing PSDay.UK – Whats a PSDay?
On Thursday evening I attended the joint London WinOps and PowerShell User Group. It was an excellent evening with two...
2017-07-24
426 reads
Calculating Travel Distance/Time in Power BI using Bing Map API
[2017-July-24] Map visualization in Power BI has drawn many data professionals into a field of ?reating visual data stories with...
2017-07-24
4,926 reads
Database Fundamentals #6: Create a Table with the SSMS GUI
The whole idea behind databases is to store information, data, in order to look at it later. The place where...
2017-07-24
536 reads
Default SQL Agent Reports – Top Jobs
Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several...
2017-07-24
464 reads
FizzBuzz–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-07-24
545 reads
Geek Sync on Wednesday: Taking Control of Your Organization’s SQL Server Sprawl
This Wednesday, July 26th, at 12 PM EDT, I’ll be giving a presentation through Idera’s Geek Sync series. You will...
2017-07-24
299 reads
Blogs
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...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
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...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers