How Much for a Laugh?
How much would you pay for a laugh? Maybe you'll donate to ensure that some of your SQL Server speakers will embarrass themselves at the PASS Summit.
Restore Gene : Automating SQL Server Database Restores
Restore Gene is a simple 2-script framework, one PowerShell script and one SQL stored procedure, which will speed up the production of restore scripts for manual disaster recovery, as well help automate log shipping.
The Hybrid Cloud: Having your Cake
With a hybrid cloud, can you get the freedom and flexibility of a public cloud with the security and bandwidth of a private cloud? Robert Sheldon explains all the ins and outs.
One System to Rule Them All
Can a single piece of software work well for most situations? Steve Jones wonders if we're not attacking the problems of large software applications in the right way.
Automating SQL Server Agent Notification
This article looks at some automated approaches of monitoring SQL Server agent jobs.
Data Mining: Part 13 Powershell
In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.
Data Mining: Part 13 Powershell
In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.
The Brittleness of Replication
Replication is a great feature in SQL Server, but it seems brittle. When things go wrong, they break quickly, and often severely. It seems that we have many features like this in SQL Server that are useful and handy, but receive very little attention as versions are released.
Adding Custom Reports to SQL Server Management Studio
In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.
SQL Saturday #320 - Raleigh, NC
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. The Triangle SQL Server user group (http://www.tripass.org) of Raleigh, NC is hosting this event on September 6, 2014. Register while space is available.
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