The ABCs of Database Creation
Creating SQL Server databases is easier than the internet may lead us to believe.
What's in your CLR?
For today's Friday poll we have a guest editorial from Jeff Moden. The head of the anti-RBAR alliance has spent a lot of time trying to help others write better T-SQL and solve their problems with code that performs well. However this Friday Jeff asks about the CLR and how you are using it, or not using it, in the real world.
Introduction to Azure SQL Data Sync
The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In thius article, Martin Policht will introduce its main characteristics.
Accelerating Your Career
There are any number of ways to help your career move forward. Steve Jones talks about one way you might not have thought about today.
Filegroup Restoring and Join Elimination
This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.
SQL Server R Services: The Basics
It is possible to do a great deal with R within SQL Server, but it is best to start by doing analysis in R on numeric data from SQL Server and returning the results to SQL Server. There is great value to be gained even with this basic foundation. Robert Sheldon is on hand to give you a kick start with the first in his series on beginning with R in SQL Server.
Microsoft IT: A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1
This paper shares the approach used to understand and determine: 1) Using ‘Hekaton’ in SQL Server 2014 against RPM, including performance analysis. 2)
Understand the specifics involved while migrating to Hekaton.
Sliding Scale Parallelism: Why Stop At DOP?
Erik Darling wonders why SQL Server doesn't have more granular parallelism options.
Fixing Plan Issues in the Middle of the Night
Do you hate when someone wakes you up in the middle of the night and tells you that some query is slower and you need to investigate it? With SQL Server 2017 you might easily do this, or even let SQL Server do this job for you.
How to Automatically Create and Refresh Development and Test Databases
In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database is big. Phil illustrates a solution by taking a set of Redgate tools to show how they can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers with the database build, taking care to save any DDL changes to the existing copies of the database.
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