Elect The Next PASS Board Members
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates...
2017-09-12
505 reads
Blog Posts
Power BI Report Server (On-Premises) for All Data Sources is Available!
Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server...
2017-09-12 (first published: 2017-08-28)
3,812 reads
Remove an Active Lease on a Blob in Azure
I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted....
2017-09-12
500 reads
Setting the Sample Rate for Auto Stats updates
SQL Server functionality can move on pretty quickly sometimes, and it’s not always all about the big features but the...
2017-09-12
2,250 reads
Someone is not following the best practices – dbatools and Pester don’t lie!
This month’s T-SQL Tuesday is brought to us by my good friend Rob Sewell (b | t) and we will "Let’s...
2017-09-12
721 reads
SQL Server: SARGability part 2
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post...
2017-09-12 (first published: 2017-09-07)
1,764 reads
SQLOrlando
We’ve haven’t had a good solution for managing money for SQLSaturday and our groups here in Orlando. In the early...
2017-09-12
429 reads
T-SQL Tuesday #94 - Automating Configuration Comparison
This month’s T-SQL Tuesday is hosted by Rob Sewell and he’s posed the following question:
What are you going to automate today with PowerShell?
I’m cheating a little bit in that...
2017-09-12
16 reads
Turn on/off Azure VMs with Powershell
T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked...
2017-09-12
446 reads
Warning Handling in dbatools Automation Tasks
So I’ve been using dbatools for automated restore tasks and came across a SQL Server Agent job that I wrote that was reporting success but the job was actually...
2017-09-12
4 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