Presentations & Blogging of 2017 in Review
And here comes the 5th time I am reviewing what happened on the presentation an blogging side of my life,...
2017-12-29
608 reads
Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)
Continuation from the previous 116 parts, the whole series can be found at http://www.nikoport.com/columnstore/
An important issue I have faced already...
2017-12-29
1,002 reads
RegEx in SSMS: A gift for quick code
I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought...
2017-12-28
722 reads
Some New Cool Features in SSMS
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...
2017-12-28
19 reads
Some New Cool Features in SSMS
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...
2017-12-28
15 reads
Some New Cool Features in SSMS
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...
2017-12-28
911 reads
Speaking in 2017
I’m done. No more trips (and no more time) to hit any events this year. As I wrote recently, I’m...
2017-12-28
636 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler or Server Side trace to something meaningful and useful...
2017-12-28
7 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
237 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
548 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