Understanding T-SQL Expression Short-Circuiting
Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.
Maximizing Throughput with TVPs
TVPs offer several performance optimization possibilities that other bulk operations do not allow, and these operations may allow for TVP performance to exceed other bulk operations by an order of magnitude, especially for a pattern where subsets of the data are frequently updated.
SQL Saturday #226 - South Florida
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 29 2013 in Davie, FL. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
Lost in Space
It seems a tremendous amount of data is lost every year on laptops in airports. Steve Jones talks about some of the issues with physical security and your portable computers.
Avoiding Parameter Sniffing in SQL Server
Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters.
SQL Server Should Work for Us
SQL Server is a great platform, but there are problems in places. Steve Jones thinks that fixing some issues might be a good investment for Microsoft.
Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.
The Best Programmers
How do keep the best programmers? Steve Jones has a few thoughts that might cause you to rethink how you manage your programming stars.
Attention users running SQL Server 2008 & 2008 R2!
Updates to the latest CUs for SQL Server 2008 and SQL Server 2008 R2 from Aaron Bertrand.
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