Using the T-SQL MERGE Statement
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability...
2014-04-13
5,726 reads
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability...
2014-04-13
5,726 reads
I have been working with SQL server for more years than I really care to mention and like to think...
2014-04-12
410 reads
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-04-11
367 reads
It’s not in the language I would write it in and it’s not necessarily safe for work, but it gets...
2014-04-11
793 reads
I was working on a script today to check the range of some values and trying to take the time...
2014-04-11
587 reads
Over time I’ve settled on quarterly goals as the best way to focus on the stuff I most want to...
2014-04-11
538 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-04-11
427 reads
Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick...
2014-04-11
660 reads
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
318 reads
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
554 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
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