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,687 reads
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,117 reads
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
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,304 reads
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
Come join Steve Jones for a day of SQL Server training in Baton Rouge on Aug 6, 2011. Free training!
2011-08-01 (first published: 2011-07-08)
2,396 reads
Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.
2011-07-29 (first published: 2010-03-24)
17,948 reads
Write your database backup to multiple files. In addition to writing your database backup to one file you have the ability to write to multiple files at the same time and therefore split up the workload. The advantage to doing this is that the backup process can run using multiple threads and therefore finish faster as well as having much smaller files that can be moved across the network or copied to a CD or DVD.
2011-07-29
4,034 reads
2011-07-28 (first published: 2009-07-01)
10,458 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers