Syncing QA data with Production
Applies to: xSQL Data Compare v7.0.0 - v9.0.0
Nowadays, Quality Assurance (QA) is a very important part of the development process for any...
2016-10-20
639 reads
Blog Posts
Syncing QA data with Production
Applies to: xSQL Data Compare v7.0.0 and higher
WARNING: this article focuses on the data transfer / synchronization task and does not address operation security issues and sensitive data scrubbing /...
2016-10-20
49 reads
Who owns your availability groups?
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...
2016-10-20
293 reads
Who owns your availability groups?
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...
2016-10-20
17,584 reads
Why Can’t I View My Power BI Content Pack?
I had a call with a customer this morning discussing different ways to publish Power BI content and how to...
2016-10-20 (first published: 2016-10-12)
1,118 reads
Why I don’t love SELECT INTO
Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...
2016-10-20
1,051 reads
Data Warehouse Fast Track for SQL Server 2016
Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to...
2016-10-19
971 reads
Fun and Contests at Summit 2016
I’ll be attending the 2016 Pass Summit as a part of the Redgate Software crew. I’m not speaking this year,...
2016-10-19
464 reads
Installing SQLCMD
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...
2016-10-19
1,152 reads
Statistics Are Vital For Query Performance
This is post #10 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
When you send a query to your...
2016-10-19 (first published: 2016-10-10)
2,090 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers