Using a Staging Environment for Tracking Down Bugs
A discussion why having a staging environment with data that mirrors production is vital to tracking down issues.
Being able to...
2011-06-08
2,138 reads
Blog Posts
Another Idea for SQLSaturday
I spend a lot of time just looking at events, watching for new ideas. At our recent SQLRally we had...
2011-06-07
642 reads
Colleges starting to offer business intelligence degrees
Interesting video on eWeek.com called Business Intelligence Takes Higher Education Students to the Head of the Class that talks about...
2011-06-07
1,224 reads
Combinations and Permutations
I ran into an interesting question from someone asking for all combinations of numbers. The thread was here, and it...
2011-06-07
15,882 reads
Free Dynamic SSIS Webinar Today
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say...
2011-06-07
638 reads
June 2011 – PASSMN Meeting Announcement
PASSMN has announced it’s June meeting. A little of the SQL and a little of the non-SQL. Get a brush...
2011-06-07
621 reads
On the exorcism of Ghost Records
There was a question earlier on one of the SQL forums as to whether or not Ghost Cleanup overwrote the...
2011-06-07
1,889 reads
Planning Your Upgrade Well
Yesterday I talked about the importance of having a tested business recovery plan. If you didn't read yesterday's post, the...
2011-06-07
968 reads
Pragmatic Tools: DTSxChange (Or DTS Must Die!)
Ah DTS packages…they suck. Seriously, it’s 2011. It’s been over a decade and we still have SQL 2000 and DTS...
2011-06-07
887 reads
T-SQL Enhancement: Sequence
Many applications need sequentially incremental number as unique/primary key for records. SQL Server 2008 supports identity columns as the primary...
2011-06-07
546 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers