The New Year - 2009
It's the first day of 2009 and Steve Jones gives a few predictions for the new year in this editorial.
2008-12-31
79 reads
Articles
The New Year - 2009
It's the first day of 2009 and Steve Jones gives a few predictions for the new year in this editorial.
2008-12-31
60 reads
The Year in Review 2008
It's the first day of 2009 and Steve Jones gives a few predictions for the new year in this editorial.
2008-12-31
85 reads
Using Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005
In a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 1, we have seen how we can come up with a disaster recovery procedure in SQL Server 2005. There are other ways to increase availability of your highly critical database in SQL Server 2005. What are those other options?
2008-12-31
2,725 reads
Moving TempDB - SQL School Video
Moving databases is fairly simple, but when you move a system database, there are a few extra steps to follow. MVP Brian Knight walks us through how to move temdb in this video.
2008-12-30
4,741 reads
SSIS Lookup using a Script Component
What would you do if you want to perform 15 to 30 lookups using the same reference dataset? This is how I did it...
2008-12-30
16,665 reads
Database conversion between the most popular DBMSs
Today many companies determine to publish their data on the Internet trying to expand their business and make their information more accessible. The IT industry proposes a wide range of original solutions for resolving data inconsistency problems that publishers inescapably face when exporting their data as they need to properly access, process and interchange large amounts of information mainly through the web.
2008-12-30
2,236 reads
Proxy Accounts in SQL Server
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them
2008-12-30
4,305 reads
SQL Bits IV - Call for Presentations
SQL Bits IV, in Manchester, UK next year on March 28th, is now looking for speakers. Please submit a session if you are interested.
2008-12-30
925 reads
Scripting INSERTs
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,647 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers