SQL Server – How to Rename Table/Column in SQL Server
To rename an object in SQL Server you can use sp_rename system stored procedure or you can do this via...
2013-03-04
2,030 reads
Virtualising your SQL Server?
Having just completed the latest revision of Learning Tree's SQL Server Virtualisation and consolidation course I thought I'd share with...
2013-03-04
675 reads
Introduction to the SQL BCP Utility
SQL Server BCP is a command line utility that bulk copies data between instances of SQL Server and data files. ...
2013-03-04
23,531 reads
SQL Server 2012 Diagnostic Information Queries (March 2013)
Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-03-04
1,070 reads
List all Objects and Indexes per Filegroup / Partition
Today, I received a call from friend asking how he can find out which database object belongs to which filegroup.
Well...
2013-03-03
1,670 reads
Baton Rouge SQL Server User Group
Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge,...
2013-03-03
712 reads
Shorten Your PowerShell Prompt
Recently, I’ve been getting very annoyed by the length of the default PowerShell prompt. Most of my work starts in my Documents folder, so with the default prompt, I’m...
2013-03-03
26 reads
FileTable: SQL Server 2012's little gasp-maker
When was the last time you looked at a SQL Server new feature list and said, “Ohhh, WOW!”? Was it...
2013-03-02
1,824 reads
MDX #27–Who are Ascendants?
Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often use in...
2013-03-02
2,461 reads
Script to clean up “Windows” logins no longer in AD
I was scanning http://dba.stackexchange.com and ran across the following question:
http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory
Basically the OP wanted to know how to get rid of...
2013-03-12 (first published: 2013-03-01)
4,160 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers