Why do I have to use a MERGE\HASH JOIN Hint?(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 2 months ago

Tips for troubleshooting queries with large result sets. read more...

add a comment |category: Database |Views: 6

tags: Database another

The End of SQL Injection; World Peace Next(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 3 months ago

My blog post on Web Application Firewalls to prevent SQL injection attacks. read more...

add a comment |category: Database |Views: 8

tags: Database another

Reacting to Bad Query Plans Programmatically(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 4 months ago

This article covers how to deal with misbehaving queries through SQL alerts. read more...

add a comment |category: Database |Views: 10

tags: Database another

Tweet! SQLblog is now on Twitter!(sqlblog.com)

submitted by StatisticsIO(240) 3 years, 4 months ago

Follow.... read more...

add a comment |category: Database |Views: 4

tags: Database another

The Cloud OS(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 4 months ago

Surely, Microsoft doesn’t expect developers to write a web app\service and connect to SSDS over the tubes even with SSL. The missing link is a cloud based application development platform. This has to be coming and I predict it to be announced at PDC. read more...

add a comment |category: Architecture |Views: 4

tags: Architecture another

Steel Cage Blogmatch: How to Configure a SAN(brentozar.com)

submitted by StatisticsIO(240) 3 years, 5 months ago

Brent O and I have a heated and humorous discussion on the topic of shared vs. dedicated drives for SQL Server. read more...

add a comment |category: Database |Views: 6

tags: Database another

Physical Design for the Future(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 5 months ago

The past, present and future of physical database design on SQL Server. read more...

1 comment |category: Database |Views: 8

tags: Database another

SQL Server 2008 Management Studio tip: Status bar Custom Colors(blog.jemm.net)

submitted by StatisticsIO(240) 3 years, 6 months ago

Nice tip for managing multiple SQL environments with good sprinkles of humor. read more...

add a comment |category: Database |Views: 8

tags: Database another

SQL Server 2005 Security Update (KB948109) fails to install with error(blog.jemm.net)

submitted by StatisticsIO(240) 3 years, 7 months ago

Gotcha to watch out for with the SQL security update. read more...

add a comment |category: Database |Views: 209

tags: SQLServer 2005 Database another

SQL Server 2008 to ship next week?(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 7 months ago

"Microsoft has told several large database shops to expect their final SQL Server 2008 bits this week. That means it's possible, in an ideal world, that the company will announce RTM (release to manufacturing) of the new database next week at the Microsoft Worldwide Partner Conference. (Microsoft is holding to its official "it'll ship in Q3" story.)" read more...

1 comment |category: Database |Views: 7

tags: 2008 SQLServer Database another

TechEd Dev Conference Day 2(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 8 months ago

TechEd dev conference day 2 review and pics read more...

add a comment |category: Database |Views: 7

tags: Database another

TechED 2008 Developer's Conference Day 1(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 8 months ago

Review of TechEd days for a SQL guys perspective's view + pic's read more...

add a comment |category: Database |Views: 5

tags: Database another

SQL people that I follow on twitter(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 8 months ago

Calling all twittering DBA's and DBD's. read more...

add a comment |category: Database |Views: 13

tags: Database another

Sqlps.exe is the New Black(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 8 months ago

SQL Server 2008 sample code on importing OS perfmon or eventlog data with powershell. read more...

1 comment |category: Database |Views: 126

tags: sqlserver2008 SQL Database another

How can something so brilliant be so evil?(or Why cursors are bad)(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 8 months ago

This is a description and code sample of the SQL injection that is being is being slung by the zombie botnet, read more...

add a comment |category: Database |Views: 12

tags: Database another

A generic WMI perfmon CLR procedure(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 8 months ago

A generic WMI perfmon CLR stored proc to run WQL queries read more...

add a comment |category: Database |Views: 19

tags: Database another