Simplify Large Queries with Temporary Tables, Table Variables and CTEs
This article demonstrates how to manage the development of complex queries by building them in stages with temporary tables, table variables and common table expressions.
The Window Is Shrinking
Today Steve talks about security and the fact that your window for lax security is shrinking for new applications.
Automatically Capturing SQL Server Performance Metrics
This article looks to provide a method that you can use to collect the author's top 10 SQL Server performance metrics automatically over time.
Hardware Hacking
Steve Jones examines one of the issues of foreign chip production: security. Will this be an attack vector in the future?
Hidden RBAR: Counting with Recursive CTE's
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
TSQL Challenge 62 - Break a long sentence in groups of 5 words
Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.
What SQL Server Books Do You Recommend
Brad's noticed that there are fewer good books about SQL Server on the shelves, and asks which books you'd recommend to people who are new to SQL Server
Adding the Script Task to Your SSIS Packages
Script tasks are a great way of extending SSIS functionality, when none of the built-in components are quite right for the task you need to perform. But how to go about creating a script task? No worries, once again Robert Sheldon is on hand to provide easy instructions on how to do it.
Free Two User License SourceGear Vault Professional
Read more about how you can get a free two user license from SourceGear and Red Gate Software.
Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers