Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
13 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
9 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...
2017-05-28
438 reads
SQL Azure Databases - Active Secondary - How to connect? - Part 2
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to a azure SQL Database primary and secondary after...
2017-05-27
13 reads
SQL Azure Databases - Active Secondary - How to connect? - Part 2
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to a azure SQL Database primary and secondary after...
2017-05-27
33 reads
Columnstore Indexes – part 105 (“Performance Counters”)
Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
For a very long time I was...
2017-05-27
769 reads
SQL Azure Databases - Active Secondary - How to connect? - Part 2
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to...
2017-05-27
637 reads
Web API 2 Interview FAQs
Web API FAQs:
1. What are the return types of Action methods in Web API?
a. Void: If the return type is void, Web API...
2017-05-27
1,063 reads
Tuning Parallelism on SQL Server
Parallelism and MAXDOP
There’s no doubt that parallelism in SQL is a great thing. It enables large queries to share the...
2017-05-26
5,320 reads
Microsoft Professional Program in Data Science – The Road So Far
I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open...
2017-05-26
1,364 reads
Blogs
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...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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