Tags » Microsoft SQL Server

Copying an on-premise Database to an Azure SQL Database

Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud. This is also the next in the ideas I got while watching Jes Borland’s ( 482 more words

SQLServerPedia Syndication

AlwaysOn 2016 – New and Improved

–by Ginger Keys

AlwaysOn Availability Groups made its debut in SQL Server 2012 as a new feature that enhanced the existing technologies of database mirroring and failover clustering to provide an option for high availability and disaster recovery. 2,060 more words

SQL Server

RBAR vs Batch

Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s most basic it means you are inserting one row at a time. 403 more words

SQLServerPedia Syndication

My First SQL 2016 Management Studio Update

I opened my local SSMS today and found my first notification of an update to SQL 2016 Management Studio today. Here is what it looks like: 154 more words

SQL Server

Write-Only permissions

Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other night and there was an interesting discussion on the idea of granting someone write permissions without corresponding read permissions. 420 more words

SQLServerPedia Syndication

Azure: What's the difference between SQL Database and SQL Server?

If you want to blog T-SQL Tuesday is a great way to get started. On the first Tuesday of each month (or possibly a bit earlier as in this case) someone presents a blogging idea. 680 more words

SQLServerPedia Syndication

SQLRx Presenting at SQL Saturday Baton Rouge 2016

SQLRx (@SQLRX) is proud to announce that two of our resident SQL Experts will be presenting sessions at SQL Saturday #515 in Baton Rouge, LA on August 6, 2016. 263 more words

SQL Server