What, when and who? Auditing 101 - Part 3
Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.
SQL Server Analysis Services Attribute Relationships
This tip looks at some of the questions around attribute relationships in SQL Server Analysis Services, including why you need them, how to create them, and the common data sets involved.
GUIDs GUIDs everywhere, but how is my data unique?
After having seen many systems that use GUIDs as the primary key for every table, it is time to say enough is enough.
Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask
Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for your query? If you get this wrong, the consequences can be serious. Deadlocks, Dirty reads, Non-repeatable reads, or poor performance. We're in luck, because Robert Sheldon once more answers those questions that are awkward to ask in public.
Introduction to Azure SQL Database Scalability
One of the primary advantages of Platform-as-a-Service solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.
Go Small
The SQL Server community is amazing, and Steve Jones hopes we continue to be close as we grow. He brings light on an idea to grow us larger, but smaller.
Tribal Awards Finalists
Voting is now open for the Tribal Awards. Vote for one of the 5 finalists in each category to win a fabulous* prize.
What To Do When the Import and Export Wizard Fails - Part II Exports
This article will discuss a case study of utilizing a SSIS package to export a table that has columns with data type varchar(mx) and text to an Excel file.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Bagaimana cara koreksi tanggal lahir di Tiket.com
Koreksi tanggal lahir Anda cukup menghubungi CS Tiket.com di nomor resmi (0821)62909071 atau melalui...
Bagaimana Cara koreksi nama di Tiket.com
Koreksi nama Anda cukup menghubungi CS Tiket.com di nomor resmi (0821)62909071 atau melalui whatsapp...
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers