6 Steps to setting up Replication with Mirroring
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
5,206 reads
Scripts
2011-06-24 (first published: 2011-06-14)
1,884 reads
Powershell - Modify Server Name in SQL 2005 SSIS Connections
This powershell script updates the server name specified in connections within a SQL 2005 SSIS package
2011-06-24 (first published: 2011-06-22)
965 reads
2011-06-23 (first published: 2011-06-20)
627 reads
Vincenty Direct
Calculates the latlon coordinates for a given bearing and distance from reference latlon coordinates
2011-06-22
555 reads
SQL DBAdmin toolbox - Part 2: Verify all databases in the enterprise
Do you verify database backups regularly? If not, you may find this toolbox solution usable.
2011-06-21 (first published: 2011-06-15)
2,004 reads
Finding all Columns of an Index
This script helps to find all columns of an index on a table. Include columns covered (include)
2011-06-17 (first published: 2011-05-31)
1,393 reads
Table row count using 3 different ways
Three different ways that you can get the count of the rows in a table.
2011-06-16 (first published: 2007-08-16)
6,563 reads
Merge Tables in SQL 2005
To merge data in SQL 2005 from various table, we do not have a MERGE function as in SQL 2008. The following script gives an alternative approach of implementing in SQL 2005
2011-06-15 (first published: 2011-06-03)
1,435 reads
2011-06-14 (first published: 2007-12-05)
5,975 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
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