SQL Server Crossword #3
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
Extracting Extended Properties
In this second article of a short series we look at using the Extended Properties which you have added to a database
SQL Server Central Webinar Series #8 - Source Control: Step One for Database Lifecycle Management
Join MVP Andy Leonard and Steve Jones in this webinar where you will learn how to get better control over your code and maintain versions using source control.
The Business - Part 2
Today we have a guest editorial by Andy Warren. This one continues the thought of how you relate to the rest of your company, or "the business" as is it often known.
Primary Keys – why accept the defaults.
G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...
Using Dynamic SQL in Stored Procedures
Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.
If you could stop working tomorrow, would you still do SQL?
Rodney landrum wonders what, if anything, you would do in SQL, or any other beloved technology, if you did not have to?
Pragmatic SSAS from BI expert Stacia Misner!
Learn dimensional modeling, cube design, MDX calculations and more in this 4 day online class from Pragmatic Works featuring BI expert Stacia Misner.
Test Before Deciding
How do you decide what improvements to make to your SQL Server? Or what settings to turn off? Having hard and fast rules isn't a great idea, and Steve Jones talks about why.
TSQL Challenge 52: Recursive Wage Calculation in a Parent-Child dimens
This challenge is intended to calculate company's wage spent below a top level manager.
Blogs
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
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