RESEED in SQL 2000 and SQL 2005/2008
This article looks at the difference in behavior of RESEED in SQL Server 2000 and SQL Server 2005/2008
2008-05-20
4,512 reads
Articles
Making the Most Out of the SQL Server 2005 Performance Dashboard
The SQL Server 2005 Performance Dashboard is a new add-on to SQL Server 2005 that became available shortly after the release of Service Pack 2 for SQL Server 2005.
2008-05-20 (first published: 2007-06-06)
7,979 reads
2008-05-20
44 reads
2008-05-20
32 reads
2008-05-20
40 reads
What BI Practitioners Can Learn From Operations Research
Growing interest in analytics and the trend toward automated decision making will lead the business intelligence crowd toward the mix of mathematical and statistical techniques used by operations researchers.
2008-05-20
2,346 reads
Name Value Pair - Part II
In this article I will try to address some of the design suggestions and experiences that I had in managing similar database.
2008-05-19
7,858 reads
Pro SQL Server 2005 Integration Services
A look at this book from James Wightman and Apress on the ETL subsystem in SQL Server.
2008-05-19
1,871 reads
Tracking Database Schema Changes with DbPro
Tracking changes to your development environments is important to ensure that your deployments to production go smoothly. Jacob Sebastion brings us a look at how well the Visual Studio Team System Edition for Database Professionals can help you with this task.
2008-05-19 (first published: 2007-07-25)
6,578 reads
Full Text Search Noise Words and Thesaurus Configurations
I have heard that Full Text Search uses a noise words to eliminate meaningless words in searches. I have also heard that a thesaurus is used, but I am not exactly sure how. Can you provide some details related to how both of these technologies are used in Full Text Search? I am interested in more of a background on these specific Full Text Search technologies as well as where the files are located and how I can update them.
2008-05-19
2,630 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...
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...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
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