Cloning SQL Servers to a Test Environment
I’ve been involved in a project to set up a full test environment of dozens of SQL Servers. The requirements...
2012-11-08 (first published: 2012-11-05)
4,261 reads
I’ve been involved in a project to set up a full test environment of dozens of SQL Servers. The requirements...
2012-11-08 (first published: 2012-11-05)
4,261 reads
Before I delve into the subject of scripting SSIS package deployments, I’m going to take a slight detour and explain...
2012-11-06
6,771 reads
The website PowershellCommunity.org is moving to a new site poweshell.org and I wasn’t sure the old forum posts will be...
2012-10-26
3,206 reads
During September/October I’ll be presenting at several in-person events:
Tampa IT Pro Camp
Join system administrators and IT professionals for the Tampa...
2012-09-09
1,118 reads
Presentation and scripts from my Storing PowerShell Output session at South Florida IT Pro Camp 2012.
2012-07-22
1,109 reads
Presentation and scripts from my Integrating SQL Server PBM with SCOM session at Jacksonville IT Pro Camp 2012.
2012-06-19
1,172 reads
Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...
2012-06-03
1,233 reads
I saw a question in the forums related to inserting new rows into a SQL Server table only if they...
2012-04-27
5,537 reads
I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...
2012-04-17
1,818 reads
I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case...
2012-04-13
3,566 reads
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers