SSIS R2 Configuration File Issue Fixed
Using configurations files in SSIS is a great way to change how your package will run from outside the development...
2010-05-14
871 reads
Blog Posts
Thoughts on Leadership
A friend is moving into a leadership role for the first time and we talked some about making that transition....
2010-05-14
954 reads
Tips from ...Rock Star DBA
Thomas LaRock (SQL Server MVP) (Blog | Twitter | LinkedIN), recently has published the new book DBA Survivor: Become a Rock Start...
2010-05-14
826 reads
Career Advice for the Novice SQL Server DBA
In April, I ran a Question of the Month that asked, “What advice would you offer a novice DBA in...
2010-05-13
979 reads
Daily SQL Server 2008 New Feature – Day 6
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-13
560 reads
Formatting Code in LiveWriter
I was getting tired of pre-formatting code in LiveWriter. I love that software, but a couple of the technical things...
2010-05-13
930 reads
Let’s Play, “Why did it do that?”
On my current project I decided to be flexible and allow the use of Linq to SQL to try to...
2010-05-13
273 reads
Live Writer - Paste from Visual Studio
This is a test of the plug in “Paste From Visual Studio”. I had this code sitting in SSMS and...
2010-05-13
806 reads
SQL Server Azure features limitation
SQL Server Azure, fully relational cloud database solution, is new possibility of the database administration and maintenance. I'm not going...
2010-05-13
1,071 reads
Upcoming SQL Lunch Webcasts
First, I would like to thank all that have attended and supported the SQL Lunch during our first year. We...
2010-05-13
696 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers