How to work around Azure database migration limitations
Microsoft Windows Azure SQL Database, commonly known as SQL Azure, is a relational database in the cloud that is part...
2013-12-14
639 reads
Microsoft Windows Azure SQL Database, commonly known as SQL Azure, is a relational database in the cloud that is part...
2013-12-14
639 reads
A critical part of database design and management is index design. Index design involves balancing space requirements and the resource...
2013-12-14
513 reads
An execution plan is the sequence of operations SQL Server query optimizer performs to run the statements. The SQL Server...
2013-12-14
1,286 reads
Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and...
2013-12-14
691 reads
Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out...
2013-12-14
564 reads
A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger...
2013-12-14
707 reads
SQL Server Integration Services (SSIS) security is based around several layers that provide a rich and flexible security environment. These...
2013-12-14
730 reads
A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of...
2013-12-14
1,675 reads
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,975 reads
I wrote last week that I had switched back from Android to iOS, but I didn’t list out specific gripes...
2013-12-13
900 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers