Introduction to Data Warehousing
In this video series, Wes Dumey shows you some of the core basics of data warehousing. Free registration required.
Moving MicrosofOne of the responsibilities of the Microsoft.com opera
One of the responsibilities of the Microsoft.com operations team is to manage the infrastructure that supports the Windows Update and Microsoft Update services, which have client bases in the hundreds of millions and growing. The Windows Update site provides critical updates, security fixes, software downloads, and device drivers for Windows operating systems. Microsoft Update is the service that brings you all the features and benefits of Windows Update.
A Look at GUIDs
Not many people enjoy using Globally Unique Identifiers (GUIDs), partly because they are cumbersome to type and work with for humans. However they fill a need and can provide some interesting benefits. SQL Server expert Andy Warren takes us through what a GUID is and how you can use it easily in your code.
DBA from Crisis to Confidence
Every DBA needs to know how to do their work under pressure, while facing crisis after crisis. Our most important contribution is to keep the database running. It's an on-call function; you never know what might happen
Using the SQL Server Surface Area Configuration
So, you’ve just installed SQL Server 2005 but don’t know how to configure it. This video will instruct you how to use the SQL Server 2005 Surface Area Configuration tool to turn on SQL Server features like CLR integration and how to enable ports. Free registration required.
Alternative to the Microsoft MMC Console
Are you frustrated by the limitations of the MMC console when managing dozens or hundreds or servers? The way Enterprise Manager is fitted into the framework can be a problem for DBAs with lots of servers. Jereme Guenther brings us a technique for his own console that solves some of the limitations of MMC.
Free SQL Prompt 2.0 valuable, but flawed; V3.0 being built from scratch
Many of you were thrilled to see intellisense available for SQL Server editors, but there has been a bit of confusion about this product. An open letter from the CEO of Red-Gate Software clears things up.
Building the MSDN Aggregation System
After agreeing on our design goals we began looking for technologies to support them. It turned out that SQL Server™ Service Broker offered the asynchronous messaging support we needed and, since the message-queuing infrastructure is tightly integrated with the SQL Server database engine, our existing database backup, administration, and failover procedures could cover our messaging solution as well.
A Fix() Function in T-SQL
SQL Server provides a decent ROUND function to help you cut off numbers after the proper number of decimal points. But what if you don't know how many decimals the number will have? Author Rob Farley brings us a UDF he built to do just this.
SQL Server 2005 Integration Services - Security - Part 28
Part 28 of SQL Server 2005 Integration Services series covers the remaining security features intended to protect the confidentiality and integrity of your packages
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers