SQL Saturday #202 - Edinburgh
Join us for a free day of SQL Server Training on June 8, 2013. There's also a Friday Preconference Training Day with Jonathan Kehayias and Joseph Sack.
Loading XML Data into SQL Server (SQL Spackle)
Learn how to load data in an XML file into a table in SQL Server.
The Bicentennial
Tomorrow is the bicentennial SQL Saturday event. SQL Saturday #200 takes place in Philadelphia, and Steve Jones has some thoughts as he travels to the City of Brotherly Love.
Why is your ASP.NET application running slow?
Any queries run against SQL Server or Oracle databases are recorded, along with how many times those queries were run and how long they took. That information is shown alongside your .NET code, so you can quickly see why the code you wrote resulted in those queries being executed. This can be particularly powerful if you’re using ORMs like Entity Framework to access data, which tend to be an impenetrable black box where performance issues can arise, but where it’s difficult to understand why.
Show off your Solutions
We're looking for scripts that you use in your daily job to find, fix, and solve issues in your environment.
Super Fast Transactional Replication Repair
Your production SQL Server transactional replication just failed and the business impact is critical. How do you get replication restored in minutes?
The Speed of Azure
There isn't a lot of acceptance of Azure from DBAs. Steve Jones talks about some of the advantages of Azure and thinks that we should be working to ensure that our internal systems respond at the same speed as people can get from Azure.
Extending SQL Server DDL Triggers for More Functionality
In this tip Aaron Bertrand describes some of the ways in which you can extend the DDL trigger functionality.
Helping MS Help Us
The Microsoft Connect system allows many of us to submit feedback, but is Microsoft doing anything with it? Join us and place your vote on some items and try to influence Microsoft.
SQLServerCentral Runs sp_Blitz - Query Plans
The fifth installment of the sp_Blitz script being run on the SQLServerCentral database server.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers