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

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

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

add a comment |category: Database |Views: 6

tags: Database another

SQLServerPedia - The Best Community Owned SQL Server Training Resource(dbalink.wordpress.com)

submitted by Marlonr(704) 3 years, 6 months ago

Now, for the very first time ever, a reliable and authoritative SQL Server Training Resource has come to life. This is some serious stuff. A heaven-sent goodness to the SQL Server Community! read more...

add a comment |category: Database |Views: 5

tags: Database another

Intel ships solid-state flash for servers and storage(news.bloglicio.us)

submitted by news(15) 3 years, 7 months ago

October 17, 2008 (Network World) Intel has started shipping new solid-state flash drives designed for servers, workstations and storage devices. Intel announced the move Wednesday with Sun, which pledged to deliver storage products using Intel’s flash technology. read more...

add a comment |category: Database |Views: 8

tags: Database another

Custom user configurable SQL Server Profiler events(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 7 months ago

SQL Server Profiler is a well known tool for tracing different activity that happens between your server and the clients connected to it. But very few people know that you can have custom events and trace them in the SQL Server Profiler. read more...

add a comment |category: Database |Views: 30

tags: 2008 SqlProfiler SQLServer Database 2005 another

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

submitted by StatisticsIO(240) 3 years, 7 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

SSMS Tools PACK 1.1 - now with SSMS 2008 support(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 7 months ago

With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express. Plus some extra features. read more...

add a comment |category: Database |Views: 240

tags: SQLServer 2008 Database 2005 another

Microsoft Announces SQL Server 2008 Experience: Microsoft continues th(microsoft.com)

submitted by beckelmw(2755) 3 years, 7 months ago

On Monday, Sept. 29, Microsoft is launching the SQL Server 2008 Experience online at http://www.SQLServerExperience.com. With more than 500 short videos in 11 different languages, the SQL Server 2008 Experience is a Web site that helps Microsoft’s global customers and partners learn more about SQL Server 2008, Microsoft’s recently released data management and business intelligence platform. SQL Server 2008 provides a trusted, productive and intelligent data platform for business-critical applications. The launch of the SQL Server 2008 Experience kicks off a worldwide readiness outreach that will reach over 350,000 customers, partners and community members through in-person events over the next year. read more...

add a comment |category: Database |Views: 9

tags: SQL2008 Videos Database another

Reacting to Bad Query Plans Programmatically(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 8 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

An interview with Louis Davidson author of pro sql server 2008(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 8 months ago

Pro SQL Server 2008 Relational Database Design and Implementation is one of those books that should be in the hands of every SQL Server developer. There are tons of SQL Server programming books around but none of them covers the fundamentals of a good SQL Server database, the design. If your design is ‘broken’ then it is a lot harder to fix it down the road, design is probably the number one reason people have all kinds of problems with their databases. read more...

add a comment |category: Database |Views: 118

tags: Database another

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

submitted by StatisticsIO(240) 3 years, 8 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, 8 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

Free eBook Offer From Microsoft: Introducing SQL Server 2008!!!(dbalink.wordpress.com)

submitted by Marlonr(704) 3 years, 8 months ago

"Peter DeBetta, the principal author of this book, welcomes readers to the soon-to-be-released SQL Server 2008. An MVP for SQL Server and a holder of many other credentials and longstanding SQL Server experience, DeBetta (with his coauthors) offers in this electronic beta book a discerning view of the new version of SQL Server." read more...

add a comment |category: Database |Views: 29

tags: Database another

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

submitted by StatisticsIO(240) 3 years, 8 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

LINQ to SQL queries involving strings cause SQL Server procedure cache(blogs.lessthandot.com)

submitted by SQL_Menace(4890) 3 years, 8 months ago

Be careful when using LINQ. If an application is using LINQ to SQL and the queries involve the use of strings that can be highly variable in length, the SQL Server procedure cache will become bloated with one version of the query for every possible string length read more...

add a comment |category: Linq |Views: 177

tags: LINQ Bug SQL Database Performance another

Free SQL Server Videos(sqlservervideos.com)

submitted by AngryPets(300) 3 years, 8 months ago

Free Training and Videos for Microsoft SQL Server. Hours of content covering tips and tricks, along with a whole slew of videos on backups. The site is still growing and there's an RSS feed you can use to be updated of newly added videos. read more...

add a comment |category: Database |Views: 347

tags: Database another

SQL Server locks: a sleeping process still holds them(weblogs.sqlteam.com)

submitted by kprernn(1445) 3 years, 9 months ago

This blog posting demonstrates how a SQL Server process can be marked a sleeping and awaiting command, yet still maintain its locks on a table. read more...

add a comment |category: Database |Views: 85

tags: Database another