Installing SQL Server 2008 on Windows 7
When Installing SQL Server 2008 on Windows 7 RTM, I encountered a couple of issues. Supposedly you can install SQL...
2009-08-15
797 reads
Active August – Week 2 Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-15
378 reads
SSIS Documentation suggestions on Microsoft Connect
For SSIS developers, the need for proper documentation is crucial. However, the built-in object for documentation, the annotation, is difficult...
2009-08-15
1,029 reads
A Couple of Invoke-SQLCMD Issues
In working on a PowerShell script to load data into SQL Server, I decided to use the Invoke-SQLCMD cmdlet included...
2009-08-14
624 reads
Evil Code
/*
A couple
of years ago, I wrote the Simple-Talk Prettifier. This is really no more than a stored
procedure that...
2009-08-14
3,556 reads
Kevin Kline Joins the SQLSaturday Advisory Council
The official announcement was just posted, Kevin Kline is the first member of the Advisory Council. As I mentioned on...
2009-08-14
1,046 reads
Book Review: The Coldest Winter: America and the Korean War
The Coldest Winter: America and the Korean War by David Halberstam ($15 at Amazon) was really the first reading I...
2009-08-14
700 reads
The Benefits of a Flexible Schedule
Both my wife and I work from home, and we've done it for years. I've been working full time for...
2009-08-14
985 reads
Upgrading your skills from SQL 2005 to SQL 2008......
Greetings, ALL:
As more and more companies get on board and begin to adapt SQL Server 2008, what is the best...
2009-08-13
680 reads
"Just smile and wave, boys. Smile and wave."
If you're not familiar with the reference, it comes from the movie Madagascar and the subsequent sequel and TV series...
2009-08-13
13,897 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...