T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions. In this article, Kathi Kellenberger provides a quick overview of just what a window function is as well as examples of each type of function.
Work sometimes gets in the way of work. Steve Jones notes this can cause stress and problems over time.
This white paper illustrates how Microsoft SQL Server Integration Services (SSIS) can be used in conjunction with commodity hardware or virtual machines running in Microsoft Azure to build elastic, highly available, and highly scalable ETL solutions.
This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.
Data breaches make the news on an almost daily basis. There is no turning back, however, as we are firmly entrenched in this digital way of life. Brian Kelley discusses some of the reasons data breaches occur and what we can do to prevent them.
SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.
What is FIPS? How do I use it? What is going to break if I do use it?
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Aktivasi QLola IB Token (Soft Token) BRI umumnya melakukan aktivasi melalui WhatsApp qlola (0819-6000-608...
Aktivasi QLola IB Token (Soft Token) BRI umumnya melakukan aktivasi via WhatsApp resmi BRI...
Comments posted to this topic are about the item The New Wave of Security...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers