T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs This blog entry is participating in T-SQL Tuesday #024, hosted this month by Brad Schulz (Blog). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just…
| News From the Frontlines |  |
Tag Archive: Dynamic Management Views
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
(2 votes, average: 2.50 out of 5)
Loading ...SQL PASS Summit 2011: Session Files
SQL PASS Summit 2011: Session Files This past week was the SQL PASS Summit 2011 in Seattle, WA. I presented three sessions (regular session, lightning talk, panel discussion) plus ran a focus group on advanced certification and hosted a Birds of a Feather lunch table on disaster recovery. It was a busy, busy week. Below…
(1 votes, average: 5.00 out of 5) Loading ...The Truth About NOLOCK Hints
The Truth About NOLOCK Hints There was a post this week from a well-known blogger who was investigating the NOLOCK locking hint. He says that he was asked whether a query using NOLOCK hint takes locks or not. After he responded that NOLOCK does not take any locks, the person who posed the question suggested…
(3 votes, average: 5.00 out of 5) Loading ...SQLU HA/DR Week – Database Mirroring Performance Counters
SQLU HA/DR Week – Database Mirroring Performance Counters Database mirroring debuted in SQL Server 2005 and had eleven performance counters for monitoring mirroring. There were ten new performance counters released with SQL Server 2008. We now have twenty-one performance counters to use for monitoring database mirroring. A list with a brief description of each can…
(2 votes, average: 5.00 out of 5) Loading ...SQLU DBA Week – Be an Efficient DBA
SQLU DBA Week – Be an Efficient DBA Welcome back for another day of Administration Week 1 for SQL University. This is day four, and I want to focus in on a term that I hear quite a bit, lazy dba. DBAs are anything but lazy, but the term seems to have come about by…
(2 votes, average: 5.00 out of 5) Loading ...Does a Mirroring Failover Clear the Procedure Cache?
Does a Mirroring Failover Clear the Procedure Cache? I saw a question on the MSDN forums asking what happens to the procedure cache (also known as the plan cache) on the principal and mirror when a failover occurs. My reply was starting to get long, so I decided to move it out to a blog…
(2 votes, average: 5.00 out of 5) Loading ...Find Cached Query Plans By Index Name
Find Cached Query Plans By Index Name A following question came in via the #sqlhelp hash tag on Twitter: Trying to find the plans using a specific index in the plan cache using XQuery – any ideas out there? #sqlhelp I replied with a little information but felt the full answer could not be shared…
(1 votes, average: 5.00 out of 5) Loading ...Finding the Text of the Previously Executed Query
Finding the Text of the Previously Executed Query This interesting question was posed on an internal discussion group today: Hello All, I apologize for reaching to this alias but I have not found any answers from another SQL alias. I have a situation with a customer that is looking to retrieve the last SQL statement…
(No Ratings Yet) Loading ...T-SQL Tuesday #011 – Top 5 Myths of Database Mirroring
T-SQL Tuesday #011- Top 5 Myths of Database Mirroring This blog entry is participating in T-SQL Tuesday #011, hosted this month by Sankar “@SankarReddy13” Reddy(Blog|Twitter). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just to read more…
(5 votes, average: 3.80 out of 5) Loading ...Advanced Tuning Presentation
Advanced Tuning Presentation Today was my presentation for the West Michigan SQL Server User Group, a SQL PASS chapter. I was presenting via Live Meeting, and it was open for anyone to attend. The files have been uploaded and are available for download Advanced Tuning PowerPoint Slide Deck (.pptx, 1.79 MB) Live Meeting Recording (.zip, 46.03 MB)…
(1 votes, average: 5.00 out of 5) Loading ...-
My SQL Server Magazine Articles
- Database Mirroring for Disaster Recovery September 16, 2011
- Comparative Review: Database Schema Comparison Tools August 24, 2011
- 3 Log Shipping Techniques June 22, 2011
- Hardening SQL Server June 20, 2011
- Review: ScriptLogic Security Explorer for SQL Server February 8, 2011
-
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS