Identity Insert Guideline
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-09-08
587 reads
Blog Posts
Importing SQL Server 2008 Analysis Server Database
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-09-08
595 reads
Labor Day Comes and Goes as Unemployment Grows......
Labor Day, which marks the unoffical end of Summer in the U.S., is particularly poignant in light of the news...
2009-09-08
850 reads
Moving your database to a new server
We've had a few articles on how you move databases, but it seems that there are always new people using...
2009-09-08
500 reads
PASS Connector Editorial for Sep 9, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-08
710 reads
Remember the Milk: Smart Adds
A while ago, Brent Ozar pointed me to Remember the Milk to help with task tracking. It's a web-based task...
2009-09-08
989 reads
Replication troubleshooting.
Hi All,Continue on Transaction replication discussion: Today I would like to share some of the important ways of handling/troubleshooting replication...
2009-09-08
661 reads
Smarter Intellisense
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I...
2009-09-08
974 reads
SpeakerRate – Need Your Feedback
Everybody loves a compliment. Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that...
2009-09-08
767 reads
Star Join Optimization in SQL Server 2008
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-08
6,186 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers