Parsing Windows event logs with PowerShell
Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possibly adding that...
2012-09-20
7,526 reads
Blog Posts
SQL Server 2012 Upgrade
SQL Server 2012 has been in RTM since the 1st April 2012. Many of my clients have been evaluating the...
2012-09-20
1,109 reads
tablediff Utility
I recently stumbled across a little gem of a utility called tablediff. I have been working a lot with replication...
2012-09-20
6,733 reads
24 Hours of PASS
Tomorrow Brian Knight and I will kick off 24 hours of PASS with a session on Choosing a Microsoft Reporting...
2012-09-19
1,186 reads
Creating a User Defined Table Type
I saw a post about a user defined table type in SQL Server and I was sure it was a...
2012-09-19
148,027 reads
Database Recovery Advisor feature of SQL Server 2012
SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases...
2012-09-19
2,391 reads
Defining Variables
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2012-09-19
756 reads
Lenovo–Three Strikes
Last Friday Lenovo told me my new laptop would ship this Monday, or “much much sooner”. Monday I called to...
2012-09-19
808 reads
Master Data Services: Expand the Leaf member attributes box
In Master Data Services (MDS), when using the Master Data Manager Web User Interface (“UI”), you will notice the “Leaf member...
2012-09-19
814 reads
Master Data Services: Versioning
In Master Data Services (MDS), you can create multiple versions of the master data within a model. When you create...
2012-09-19 (first published: 2012-09-17)
3,322 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...