Performance Tuning Series
To kick off this blog, I am going to start with a topic that is hot on the mind of...
2010-06-03
758 reads
The Nature of the Database-Driven Developer
Bear with me as I wax philosophical for two sentences. Our societies are becoming more polarized with each passing day. ...
2010-06-03
689 reads
One more Fix Database Role in SQL Server
Fixed Database Rols are: db_ddladmin, db_owner, db_accessadmin, db_securityadmin, db_backupoperator, db_datawriter, db_datareader, db_denydatawriter, db_denydatareader + one more that is dbm_monitor.
This is...
2010-06-03
1,711 reads
Slides from SQL Server Auditing Class
Here are the slides from the SQL Server Auditing Class held on June 2, 2010.
Hour 1 - Attacking SQL Server
Hour 2...
2010-06-03
1,029 reads
List of indexes and Parallel queries
Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing...
2010-06-03
469 reads
SQL 2008 r2 version comparison
Comparison between Enterprise and Standard Versions of SQL 2008 R2
I’ve found myself recently trying to justify the need for Enterprise...
2010-06-03
10,154 reads
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
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
Daily SQL Server 2008 new Feature – Day 15
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-03
403 reads
Drive Space
I found a cool series of scripts from Jeremiah Peschka on getting disk space from SQL Server. They’re useful queries,...
2010-06-03
1,983 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