Move Azure SQL Databases using the Export and Import PowerShell cmdlets
John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.
2017-03-08
3,664 reads
Additional Articles
Query Store and In-Memory OLTP
Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.
2017-03-07
4,670 reads
Finding the Worst Performing TSQL Statement
Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.
2017-03-06
5,202 reads
Clone a SQL Server login and password to a new server
Bhavesh Patel shows how to clone a SQL Server login onto another server while keeping the password the same.
2017-03-03
4,570 reads
How to Programmatically Determine Which Edition of SQL Server is Installed
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
2017-03-02
3,772 reads
DevOps and “Shift Left” for Databases
The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least...
2017-03-01
5,552 reads
One way to get an index seek for a leading %wildcard
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
2017-02-28
5,792 reads
Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data
SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more makes it all seem easy.
2017-02-27
5,321 reads
Using SQL SERVER and Cloud Hosted Databases with OBIEE 11g
If your organisation is committed to using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g /12c as their BI solution, you aren't thereby committed to using Oracle throughout your organisation. You can use a range of data sources including SQL Server, and save a great deal of money by doing so. Sadly, Oracle will only support the use of the venerable SQL Server 2008 R2. Zafar Ali demonstrates how to connect OBIEE to the world beyond Oracle.
2017-02-24
4,245 reads
Performance Surprises and Assumptions : GROUP BY vs. DISTINCT
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
2017-02-23
8,502 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
BCA KCU RAWAMANGUN Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers