The Microsoft SQL Server product group are evaluating how to better assist with your SQL Server upgrades. With the upcoming SQL Server 2005 extended support deadline fast approaching, they want to understand how to help you migrate to a modern, supported version of SQL Server, and how to provide support and upgrades in future.
How many hours per week do you spend writing the same SQL again and again?
Everyone wants to know who is actually using Continuous Deliver for their software. Today Steve Jones has a prominent example.
Solution to overcome SSIS Package Catastrophic Failure Error
By reading performance counters from services such as SQL Server or Exchange, you can get a wealth of performance information. By automating the process of gathering and storing appropriate counters, you can routinely check a range of devices quickly using visual tools such as PerfMon. By then creating your own counters, you can add counter-based metrics to anything that can be measured programmatically, such as services, applications, processes such as ETL, or deployments. Nicolas Prigent shows you how.
A vulnerability has been released that can affect SQL Server 2008, 208 R2, 2012, and 2014.
SQL Server 2016 introduces a new security feature called Dynamic Data Masking (DDM). This tip describes its purpose, shows a brief example of how it works, lists some limitations, and notes how the feature has already changed since CTP 2.0 was first released in May.
Is it more imortant to use the data or your experience? Does one have more weight than the other?
How we can use SQL to solve a math problem published in The Guardian...but with a caution about implicit type conversion.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Comments posted to this topic are about the item Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers