A Dearth of Comments
Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?
2009-01-04
716 reads
Articles
Getting Data out of SQL Server from Powershell
In the first article, we learned how to move data into SQL Server. This time Chad Miller shows us how we can use Powershell to extract data out of SQL Server.
2009-01-02
23,333 reads
Kilimanjaro, Gemini and Madison - Get the lowdown
An interview with Herain Oberoi, group project manager for the SQL Server Business Intelligence and Data Warehouse product.
2009-01-02
2,872 reads
SQL Server Management Studio for Beginners - SQL School Video
Learn the basics of how to work with Management Studio in this SQL School video.
2009-01-01
8,115 reads
Data Quality and Data Profiling
David Loshin describes the benefits of the combination of the bottom-up aspects of data profiling with a top-down analysis phase for establishing criteria for data quality management.
2009-01-01
2,313 reads
Industry Experience... Required?
This Friday, a guest poll and editorial from Adrian Nichols wondering about the value of experience in a particular area.
2009-01-01
135 reads
Industry Experience... Required?
This Friday, a guest poll and editorial from Adrian Nichols wondering about the value of experience in a particular area.
2009-01-01
128 reads
Industry Experience... Required?
This Friday, a guest poll and editorial from Adrian Nichols wondering about the value of experience in a particular area.
2009-01-01
140 reads
Use Excel to DIFF Your Query Outputs
Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.
2008-12-31
1,352 reads
Temporal Datatypes in SQL Server
In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses SQL's temporal data types and agonizes over the fact that, although there are ANSI/ISO Standards for temporal operations in SQL, every vendor has something different.
2008-12-31
1,141 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