Become an ETL Expert
Learn ETL solutions from SQL Server MVP Brian Knight at the SQLServerCentral.com training center.
Introduction to Deploying SSIS Packages
In this session, you'll learn the basics on how to deploy an SSIS package to the package store. You'll learn the benefits of whether to use the MSDB database or file system to store yoru packages and how to use configuration files to simplify migrations.
Writing Maintainable Code
No developer or DBA wants to be told how to write their code. Everyone has their own style, but this can cause problems in a team environment where different people need to work on the same section of code. New author Pam Abdulla brings us a few simple techniques that can help you write more maintainable code.
Using correlated sub-queries in SQL Server
A sub-query is a SQL Server statement embedded inside of another SQL Server statement. The database engine treats a sub-query as a virtual table for the execution of the query. A sub-query can be used as a table in a join statement, as a single value in a select statement, in the where clause of a SQL Server query, in the having clause of a SQL Server query, or incorporated in data manipulation statements.
Dumping Microsoft SQL Server: MySQL, PostgreSQL attract big users
So, you're a Microsoft SQL Server administrator flirting with open source, but you're not sure how far you should go on the first migration? Don't worry, there won't be much peer pressure to go "all the way." Look around and you'll find that most businesses making the switch are going only as far as their Web applications.
SQL Server Spotlight on John Gallardo
After he worked on the XML features of SQL Server 2005, he has moved on to Reporting Services. John Gallardo is an interesting person with a variety of thoughts on XML and more.
Committing imports in SQL Server a little at a time
A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix supports wildcards in LIKE and MATCH predicates, this support does not include TEXT columns. The obvious solution—to export the data to SQL Server—does support such searches.
Creating a generic audit trigger with SQL 2005 CLR
Auditing is becoming more important all the time for DBAs as regulations and requirements increase. Building auditing into your systems can be done a number of ways, but with SQL Server 2005, you have a new option. New author David Ziffer brings us a generic auditing CLR trigger.
Introduction to Data Warehousing Part 2 - DW Tables
In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse. Free registration required.
ConnectionStringBuilders in .NET 2.0
As a DBA you might not need to build connection strings for your servers very often, but developers certainly need to build these all the time and might contact you for help. Author Raj Vasant takes a look at the new capabilities of .NET 2.0, which can really help make this easier.
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers