Making New Infrastructure Investments
One of the areas where the cloud may have the most impact is with new infrastructure improvements. Steve Jones talks about a few companies that are using the cloud in different ways.
SQL Server 2012 Integration Services - Package and Project Parameters
In SQL Server 2012, Microsoft introduced SQL Server Data Tools to accommodate the dynamic nature of SSIS constructs in the form of package and project parameters. This approach lets you combine multi-package projects into a single unit, eliminating the possibility of breaking dependencies between parent and child packages during subsequent deployments.
Management - Level 9 in the Stairway to Reporting Services
In the last article of the series, you will learn how to manage your reports once you've finished development, including how to use the Report Manager, deploy reports, and send reports to the appropriate end users.
Work around for calculating age using the SQL Server DateDiff function
Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.
New features in SQL 2012, the contained database
This article describe the problems about the migration of the databases and logins and the new feature contained databases
The TCO of the Cloud
When is the cloud right for your databases? Steve Jones talks about some metrics and ways you can measure your usage to determine when it makes sense.
SQL Server Central Webinar Series #18 - Don’t Lose Your Data: Top Tips for Backup, Verification and Restore
Join us on May 22, 4:00GMT to learn how to include verification as a part of your backup and recovery strategy with Grant Fritchey.
Windows Azure from a Data Perspective
Before creating a data application in Windows Azure, it is important to make choices based on the type of data you have, as well as the security and the business requirements. There are a wide range of options, because Windows Azure has intrinsic data storage, completely separate from SQL Azure, that is highly available and replicated. Your data requirements are likely to dictate the type of data storage options you choose.
Continuous Releases
The idea of continuous development, integration and release can be a way to get your software in use by clients quicker. Steve Jones talks about releases, and some benefits you might get.
Instant File Initialization and restores
Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers