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
839 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
637 reads
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,197 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,212 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
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers