New Article: Return SQL Server Connections Information Using sys.dm_exec_connections
I’ve started a new series at MSSQLTips.com walking through the various Dynamic Management Objects we have available to us in SQL...
2018-05-18
402 reads
Blog Posts
Quick Table Info Export with PowerShell
This week I had a user come to me asking about how fields were defined on a few tables he was using in writing some reports. Long story short,...
2018-05-18
14 reads
Randomizing Names with Data Masker
Data Masker for SQL Server is pretty cool. It can reduce your attack surface area and exposure under the GDPR...
2018-05-18 (first published: 2018-05-07)
3,189 reads
Why I blog: TSQL Tuesday #102
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given...
2018-05-18 (first published: 2018-05-08)
1,815 reads
Automate SQL Server Database Restoration using bacpac with PowerShell or Batch techniques
Data is the key to your organization’s future, but if it’s outdated, irrelevant, or hidden then it’s no good. Maintenance...
2018-05-17 (first published: 2018-05-08)
4,716 reads
Creating Custom Conditions In SQL Server Policy Based Management
In my last post I covered some basic policy based management examples, in this post I want to cover writing...
2018-05-17
63 reads
Creating Custom Conditions In SQL Server Policy Based Management
In my last post I covered some basic policy based management examples, in this post I want to cover writing...
2018-05-17
60 reads
Day 17 Backup and Recovery
There are there types of Backup: Full Backup Incremental Backup Bin-Log Backup Full Backup: is a complete backup of the...
2018-05-17
240 reads
Installing OpenSSH Server on Windows 10
So in yesterday’s post we learned that the OpenSSH client is included with the Windows 10, Update 1803! Guess, what else is included in this server, an OpenSSH Server! Yes,...
2018-05-17
16 reads
Installing OpenSSH Server on Windows 10
So in yesterday’s post we learned that the OpenSSH client is included with the Windows 10, Update 1803! Guess, what else...
2018-05-17
2,552 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