Should DBAs have local administrator rights?
This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...
2009-11-25
8,179 reads
Blogs
Change the Report Manager logo
A common question I've been asked a lot lately is how to replace the icon in the Report Manager to...
2009-11-25
4,971 reads
How to Create a Reporting Services 2005/2008 Template
At most large companies one business requirement is that all reports have the same look and feel. This may vary...
2009-11-24
5,979 reads
Maintenance Plan clean up task - not working to plan
A colleague of mine who is getting to grips with SQL Server had an issue after creating and implementing a...
2009-11-23
1,829 reads
Get 25% Off SQL Server E-Learning from Microsoft
Not all DBAs have the opportunity to attend formal classroom training or attend conferences. While there are many SQL Server...
2009-11-23
841 reads
MDX, DMX, and XMLA Templates
One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....
2009-11-20
1,217 reads
SQL Lunch Recordings Now Available
After several tries I think we finally have it working. If you were unable to attend the last two SQLLunches,...
2009-11-20
1,911 reads
Flight or Invisibility: Which do you Choose?
A colleague of mine pointed out a great podcast called This American Life - specifically an episode with John Hodgman (the...
2009-11-18
1,076 reads
SQL Server 2008 Database Mirroring in Action
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
2009-11-17
1,413 reads
Super Seven Cleanup Steps Before Deploying Your Cube
Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the...
2009-11-16
1,285 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
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers