1 year of blogging
It’s hard to believe but a full year has now passed as of today. It’s my blogoversery! Can that be...
2017-06-22
431 reads
Move a Stored Procedure to a New Schema–SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-06-22
520 reads
VSCode – PowerShell extension 1.4.0 new command Out-CurrentFile
Yesterday David Wilson announced version 1.4.0 of the PowerShell extension for VSCode
Just released #PowerShell for VS @Code 1.4.0 with new...
2017-06-22
907 reads
Blog Series: Azure Cloud “Fear” Busting
I have decided to do a 4-part series on Cloud “Fear Busting” scenarios. Why? Over the past few years working...
2017-06-22
404 reads
Have you backed up your SQL Logins today?
Why am I asking?
Have you never have been in a situation where:
the master backup is corruptedyou need to rollback a password...
2017-06-22
416 reads
How to Automate Processing of Azure Analysis Services Models
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
539 reads
How to Automate Processing of Azure Analysis Services Models
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
2,588 reads
Why You Need A Test Environment
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
135 reads
Combating SQL Injection
Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common?...
2017-06-21
803 reads
Working on my Microsoft Professional Program for Data Science
Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their...
2017-06-21
478 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