T-SQL Tuesday coming next week
The T-SQL Tuesday party #7 is coming next Tuesday, June 8th. Since it’s TechEd week, and I’ll be there along...
2010-06-03
390 reads
Blog Posts
Weekly Update - Internet Issues
I haven’t written anything technical or SQL Server related for that matter on my blog for a few of weeks....
2010-06-03
640 reads
Alternating Group Colors
Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my...
2010-06-02
509 reads
Calculating ROI on Performance Tuning
Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they...
2010-06-02
753 reads
Daily SQL Server 2008 New Feature – Day 14
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-02
336 reads
Inventory SQL Servers with CLR Function
In an enterprise with several SQL Server instances it is pivotal that you keep track of each instance and its...
2010-06-02
737 reads
Speaking at SQL Saturday #22 - Pensacola, FL
If you are near Pensacola, FL this weekend, I will be speaking at their SQL Saturday on June 5th, 2010. I will...
2010-06-02
752 reads
SQL Server 2008 and 2008R2 Diagnostic Information Queries for June 2010
This version has updated build lists for SQL Server 2008 and 2008 R2. It also has several new queries, and...
2010-06-02
1,563 reads
Submitted Session Abstracts for PASS Summit 2010
I guess I will join the trend, and list the session abstracts that I submitted for PASS Summit 2010. There...
2010-06-02
907 reads
Table Variables
I was never a big fan of temp tables, mostly because there were serious contention issues in SQL Server v6.5....
2010-06-02
1,012 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