The Eleven Days of Festivus
It’s that time of the year again – the Festivus season is upon us! In the next few weeks, families all...
2016-12-12
305 reads
Blog Posts
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...
2016-12-12
27 reads
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t...
2016-12-12
353 reads
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...
2016-12-12
87 reads
Aggregate Functions
Aggregate Functions
MINReturns the smallest value in a given columnMAXReturns the largest value in a given columnSUMReturns the sum of the...
2016-12-11
251 reads
My Interview at SQL Server Geeks 2016
One of the biggest highlights of this year for me was speaking at SQL Server Geeks Annual Summit 2016. In...
2016-12-11
395 reads
Linux – How to generate and configure SSH Key authentication to connect to a remote system
Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...
2016-12-10
391 reads
Friday Reading 2016-12-09
One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to...
2016-12-09
368 reads
Hide and Group Columns in SSRS Using a Parameter
Ever had users come to you and request another version of a report just to add another field and group...
2016-12-09
616 reads
In Memory OLTP – 2
Good day everyone , In last post
In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...
2016-12-09
509 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