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
765 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
706 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,717 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,033 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
473 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,169 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
394 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
643 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
408 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,989 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers