SQL Server : Index at a glance
In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...
2013-04-16
1,244 reads
Connecting to SSIS 2008 Without Local Admin
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
59 reads
The Bucket List – Item #1 is (finally) finished
We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the...
2013-04-16
749 reads
MCM Road Less Traveled
I began this post back in October of 2012 after learning that I had passed the SQL Server 2008 MCM Knowledge exam. I had set it aside in hopes...
2013-04-16
13 reads
MCM Road Less Traveled
I began this post back in October of 2012 after learning that I had passed the SQL Server 2008 MCM...
2013-04-16
957 reads
SQL Server : Part 10: Importance of Key Column Position While Creating Index
Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...
2013-04-22 (first published: 2013-04-16)
6,628 reads
SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Here I share a free and easy way for you to get valuable insight into the...
2013-04-16
168 reads
SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy...
2013-04-16
2,492 reads
SQL Server 2012 Diagnostic Information Queries (April 2013)
Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-04-16
945 reads
Cumulative Updates - SQL Server 2012 RTM CU7
A 7th Cumulative Update is available for those users still on the RTM branch of SQL Server 2012. This is in keeping with Microsoft’s Incremental Service Modelling.
http://support.microsoft.com/kb/2823247You may have...
2013-04-16
10 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