Extending SQL Server DDL Triggers for More Functionality
In this tip Aaron Bertrand describes some of the ways in which you can extend the DDL trigger functionality.
2013-05-30
4,116 reads
Additional Articles
Database Deployment: The Bits - Agent Jobs and Other Server Objects
Databases often need more than just the database objects to run. There may be certain server objects and components, and SQL Agent objects, that are required as well. For an automated deployment, these need to be identified and their build script placed in source control. They then need to be deployed via the pre, or post deployment script. Phil spells out how and why.
2013-05-29
2,424 reads
Uploading Data to Windows Azure SQL Database
One way of getting the advantages of the Cloud without having to migrate the entire database is to just maintain a copy of the data that needs to be accessible to internet-based users in Windows Azure SQL Database. There are various ways of keeping the two in sync, and Feodor Georgiev describes a solution based in using SSIS.
2013-05-28
3,252 reads
Updating the TCP Port on a SQL Server Cluster Node
When installing 2 SQL Server instances on a Windows Cluster, the installation program requires a Named Instance during the installation of the second node and a dynamic TCP port is created. How do you update the TCP port after the installation in a clustered environment for the named instance?
2013-05-27
4,419 reads
Using source data from an SSRS report in PowerPivot for Excel
In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.
2013-05-24
4,528 reads
Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets
There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.
2013-05-23
3,650 reads
Paging Data with T-SQL
Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.
2013-05-22
5,165 reads
Centralizing SQL Server Express Job Scheduling
I'm interested in monitoring all my SQL Server backups, but for SQL Server Express we're currently using scheduled backups using Windows Task scheduler on each SQL Server Express since SQL Agent does not come installed on Express Editions. Is there an alternative where I can utilize my existing SQL Server infrastructure?
2013-05-21
3,108 reads
Azure SQL Database Maintenance
It is increasingly likely that DBAs are now given responsibility for maintaining Azure SQL databases as well as conventional SQL Server databases. What is likely to be required by way of maintenence? What are the differences? Grant Fritchey covers what you need to know.
2013-05-20
2,964 reads
Getting Started Formatting SSRS Reports
Once you've prepared an SSRS report, it needs formatting to get it ready for the people who need to read it. This tip covers the basics of formatting SSRS Reports.
2013-05-17
4,234 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers