Consolidating Error Logs from multiple SQL Servers using SSIS
SQL Server stores all informational messages, warning messages, and errors in operating system and application log files. As a database...
2013-04-14
929 reads
SQL Server index related dynamic management views and functions (Part 1)
Microsoft SQL Server provides DBAs and Developers with several index related dynamic management views and functions, which they can use...
2013-04-14
835 reads
Presentation Materials “What Are You Waiting For?” #SQLSat211
After lunch, I led the session “What Are You Waiting For?” at SQL Saturday Chicago #211. It was another well-received...
2013-04-13
519 reads
Assorted Links for April 13, 2013
Consider adding Troy Hunt to your feed listGreat post about the role of staffing firms in your job search and...
2013-04-13
644 reads
Presentation Materials “Discovering the Plan Cache” #SQLSat211
Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get...
2013-04-13
447 reads
SQLMentor: Do you have a mentor?
I’ve been looking for better ways of learning and improving my SQL Server skills. Blogs, BOL, webcasts, and training videos...
2013-04-13
733 reads
Parsing Glenn Berry’s Diagnostic Information Queries With PowerShell
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,266 reads
Introduction to SQL Server 2012 – Webcast Resources
First, I would like to thank everyone for joining my webcasts today. Very much appreciated. Secondly, I would like to...
2013-04-12
1,040 reads
Data Warehousing Tip: Surrogate Key Generation
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to do a table based surrogate key assignment or use...
2013-04-12
24 reads
Data Warehousing Tip: Surrogate Key Generation
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to...
2013-04-12
937 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