Free Two User License SourceGear Vault Professional
Read more about how you can get a free two user license from SourceGear and Red Gate Software.
2011-08-05 (first published: 2011-07-05)
3,317 reads
Articles
Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
9,008 reads
How to Compare the Data in Two Tables Without Any 3rd-Party Tool?
SQL Server ships with the tablediff utility which can be used to compare the data in two tables. Read this article to learn it step-by-step:
2011-08-05
5,436 reads
2011-08-04 (first published: 2009-07-15)
10,124 reads
Down the Rabbit Hole – A Study in PowerShell Pipelines, Functions, and Parameters
For an experienced programmer to learn a new language can be a journey quite like Alice's in wonderland. Paradoxes, unexpected twists, blind tangents, bafflements and nice surprises. Michael Sorens comes to the rescue of anyone learning PowerShell with an explanation of how to use PowerShell functions.
2011-08-03
2,338 reads
2011-08-02 (first published: 2009-07-08)
9,682 reads
Speeding Up Database Access Part 3 - Fixing Missing Indexes
Learn how to add those indexes you need in part 3 of Matt Perdeck's 8 part series on improving data access. This is based on the book ASP.NET Site Performance Secrets.
2011-08-02
9,113 reads
SQLServerCentral.com Best Practices Clinic: Part 5
In this article, Brad McGehee takes a brief look at four resource intensive queries that are running on the SQL Server instance that runs the SQLServerCentral.com website. Don't miss out on the competition in this article.
2011-08-02
2,220 reads
Extract Objects from SSRS Reports
A discrete list of database objects is extracted from SSRS using SQL, SSIS, and RegExtractor in order to identify reports that might break when a schema upgrade is performed.
2011-08-01
9,264 reads
CLR Performance Testing
Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.
2011-08-01
2,863 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers