SQL Saturday is coming to Dallas on November 2. This is a free, one day conference for SQL Server training and networking.
On November 1, there will be a pre-conference event featuring Andy Leonard, Grant Fritchey, and Drew Minkin.
2013-10-24
3,031 reads
SQL Server Reporting Services (SSRS) has evolved over the years to incorporate many new data visualization capabilities. In this article, Scott Murray illustrates how DBAs can use these tools to produce reports that include Indicators, Embedded Charts, Sparklins, and Chart overlays.
2013-10-24
6,148 reads
When pushing a major release to a large production database, you want to know that you'll be able to rollback changes if the need arises. These are some simple steps which we can follow to ensure that we don't have to reconfigure log shipping all over again thereby saving time and ensuring systems are not affected when rolling back changes.
2013-10-23
3,892 reads
With all of the ETL tools in the marketplace, which one is best? Jeff Singleton brings us simple performance comparison pitting SSIS against open source powerhouse Talend.
2013-10-22
14,651 reads
In this article, Marcin Policht looks at migrating existing SQL Server databases to Windows Azure, starting with identifying obstacles associated with such migrations.
2013-10-22
3,910 reads
Collect your data from your servers easily using linked servers.
2013-10-21
4,554 reads
This article is an extract from the book Tribal SQL. In this article, Mark S. Rasmussen offers a concise introduction to the physical storage internals behind SQL Server databases. He doesn't dive into every detail, but provides a simple, clear picture of how SQL Server stores data.
2013-10-21
3,767 reads
This article describes a design pattern for storing “effective dated" changes to fact tables.
2013-10-18 (first published: 2010-12-22)
20,764 reads
One of the benefits of running SQL on virtual environment is the capability to present additional vCPUs to the virtual server online and real-time without interruption to running processes. Our VM administrator normally presents only 1 vCPU on the virtual server and extends as required. This article describes how SQL Server is able to detect hot-added vCPUs in my virtual server.
2013-10-18
2,865 reads
Download the latest preview of the the next SQL Server version for testing.
2013-10-18
4,775 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
BCA KCP Sampoerna Strategic Square Telpon/WA:08137887595.Gd. Sampoerna Strategic Square, Jl. Jenderal Sudirman Tower A...
Jl. Pluit Permai No.Raya 60, Pluit, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta...
BCA KCP Sudirman Mansion Telpon/WA:08137887595.Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers