2013-02-13 (first published: 2013-01-25)
2,038 reads
2013-02-13 (first published: 2013-01-25)
2,038 reads
This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.
2013-02-12 (first published: 2013-01-18)
799 reads
Simple script which create a list of all the tables and rows of the selected DB.
2013-02-11 (first published: 2012-12-21)
1,202 reads
2013-02-08 (first published: 2012-12-27)
1,582 reads
T-SQL that allows you to import tab delimited text file into correct table based on file name.
2013-02-07 (first published: 2012-12-27)
2,361 reads
2013-02-06 (first published: 2012-12-27)
1,891 reads
Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes.
2013-02-04
3,366 reads
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
967 reads
Database Users and their Corresponding Roles and type login.
2013-01-28 (first published: 2013-01-16)
2,143 reads
One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.
2013-01-24 (first published: 2013-01-16)
632 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