How NOLOCK Will Block Your Queries
Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...
2017-10-10
392 reads
Blog Posts
Kill a Connection, Session, or Command in Analysis Services
One of the useful features of the SSAS Activity Monitor is the ability to cancel sessions and queries. Though there is...
2017-10-10
3,158 reads
Power BI Custom Visuals Class (Module 71 – Timeline Storyteller)
In this module you will learn how to use the Timeline Storyteller. The Timeline Storyteller is a great way to...
2017-10-10 (first published: 2017-10-02)
2,036 reads
Toolbox - Fix Your FILEGROWTH
One of the items we usually flag in reports is FILEGROWTH by percentage. It doesn't help that for most versions...
2017-10-10 (first published: 2017-10-05)
1,834 reads
Checking Out SQL Vulnerability Assessment
Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool...
2017-10-09 (first published: 2017-09-28)
1,591 reads
Microsoft Ignite US 2017 – Major Azure Announcements
[read this post on Mr. Fox SQL blog] Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major announcements across the entire solutions portfolio suite –...
2017-10-09
20 reads
Microsoft Ignite US 2017 – Major Azure Announcements
[read this post on Mr. Fox SQL blog]
Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major...
2017-10-09
454 reads
SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing
“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose...
2017-10-09 (first published: 2017-09-29)
2,325 reads
The evolution of SQL Server towards Digital Transformation challenges
SQL Server on Linux boosts the database market for Microsoft. Support of PolyBase (a feature to work with Big Data...
2017-10-09
365 reads
Using xp_delete_file
First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions,...
2017-10-09
1,179 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
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...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
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