Memories of 2013
It's the last Friday of 2013 and Steve Jones asks you to look back at the year. What stands out in your mind that relates to SQL Server.
The Importance of Validating Backups
You may think that if your database has backed up without errors, that it's going to restore without errors. Think again, says Paul Randal.
The PoSH DBA - SQLPSX: SQL Server PowerShell Extensions
Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed to provide intuitive functions around the SMO objects. Laerte Junior, who is one of the developers on the open-source project, describes how to use it.
It's not the platform
Steve Jones doesn't think that it matters which platform you choose. It's more about the people you have.
Generate multiple SSIS packages using BIML and metadata
Although BIML is very powerful, you wouldn’t use it to generate one package at a time. Using metadata, we can generate multiple packages on the fly. Koen Verbeeck illustrates how to convert the BIML script for generating the import package to a dynamic package generating machine.
How to Compare Rows within Partitioned Sets to Find Overlapping Dates
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
Parameterized Queries
A Greg Larsen classic - he discusses how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2
Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.
Creating Inferred Dimension Members with SSIS
This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.
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