Surface Possibilities
The Surface is Microsoft's tabletop computer that can be controlled with your hands and doesn't require a keyboard. Is there value in this system for DBAs?
2009-01-16
637 reads
Articles
Surface Possibilities
The Surface is Microsoft's tabletop computer that can be controlled with your hands and doesn't require a keyboard. Is there value in this system for DBAs?
2009-01-16
607 reads
Use Access 2007 to Get Started in Data Mining
Learn how you can use Microsoft Access 2007 as a basic data mining tool for exploring your valuable data. This article illustrates how data filters, pivot graphs, queries in graphs and filters in reports can help this cause.
2009-01-16
2,832 reads
Generating Random Results - SQL School Video
How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.
2009-01-15
3,196 reads
Managing many SQL Servers?
Here's an article from Rudy Panigas on how to more effectively manage multiple servers.
2009-01-15
8,967 reads
Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005
In a previous tip on Switching Execution Context using the REVERT clause, you have seen how to switch execution context to a more privileged user and revert back to the original context of the caller within a programmable object. The REVERT clause accepts a parameter WITH COOKIE to provide an even more granular option. How do we use it?
2009-01-15
3,036 reads
Obtaining Index Usage Information
This article shows how the sys.dm_db_index_usage_stats DMV can be used to tune your indexes, and maximize the performance of your database
2009-01-15
2,706 reads
Checkpoints in SSIS
Integration Services has a lot of features to enable to you perform ETL operations on data moving into SQL Server. Longtime author Dinesh Asanka brings us an article on
2009-01-14
12,208 reads
Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation
Recent installments of our series have discussed configuring Service Broker full dialog level security, which required a mechanism to facilitate the exchange of certificates between communication partners. In this article, we will present an alternative approach, which eliminates this requirement by relying on anonymous dialog security.
2009-01-14
1,550 reads
Identifying Windows Volumes on a Clustered SQL Server Instance with the DMVs
I am trying to determine which of the logical volumes on the shared disk are associated with each SQL Server instance. Is there a simple method in T-SQL to determine this without having to fire up Cluster Administrator?
2009-01-14
2,392 reads
Blogs
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
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 ...
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