SSDT DevPack + Visual Studio 2017
I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and...
2017-05-08
54 reads
SSDT DevPack + Visual Studio 2017
I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and...
2017-05-08
62 reads
SSDT DevPack + Visual Studio 2017
I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and have started to think about how to improve it...
2017-05-08
10 reads
Copy-SqlJob, a handy dbatools cmdlet
One of the things I’ve often needed to do is move jobs around between instances of SQL Server. I’ll often...
2017-05-23 (first published: 2017-05-08)
1,781 reads
General Notes on Security in Azure SQL Data Warehouse
I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you...
2017-05-22 (first published: 2017-05-08)
1,177 reads
Slides from SSWUG 2017 Spring Virtual Conference
As promised, here are the slides for my two presentations from SSWUG’s 2017 Spring Virtual Conference:
SSWUG_Spring_Building an Auditing Framework for...
2017-05-08
329 reads
SQL Saturday Louisville precon – interview Andy Leonard
This will be year #9 of sql saturdays in Louisville. Every year (starting with 3rd or 4th), it has been...
2017-05-08
446 reads
SQL Server Recovering Data via a Hex Editor
I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised...
2017-05-08
411 reads
Monday Coffee 2017-05-08
Asking stupid questions
Oh boy have I asked some stupid questions in my time. Most recent was this question that I...
2017-05-08
335 reads
Using The SQL Server Merge Statement
Note : Since publishing this I’ve been notified that there are a number of outstanding issues with the SQL Server merge...
2017-05-08
61 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
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...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers