Enabling Remote Access to the Dedicated Admin Connection
Recently I was running a health check on one of my clients SQL Servers and I noticed that access to...
2017-01-30
3,114 reads
How to compare two SSAS databases with a custom MDX query
[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...
2017-01-29
2,785 reads
Worth Reading – Something I learned while unemployed by Rod Falanga
SQLServerCentral recently published Something I learned while unemployed. Written by Rod Falanga, it has lessons worth learning about making time to...
2017-01-28
832 reads
SQL and the other technologies
Next table shows how SQL stands with the other technologies. The data is taken from StackOverflow.Data charted looks like in the...
2017-01-28
455 reads
SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
12 reads
SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
14 reads
SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation...
2017-01-27
285 reads
CloudProPT – The New Cloud/Azure Community in Portugal
I am so happy to share the news that as of today, the new community CloudProPT (as in Cloud for...
2017-01-27
461 reads
Finding Sysadmins with dba tools–GetDbaRoleMember
I’ve been wandering through the dbatools set of cmdlets, trying to see where various cmdlets are useful, and also practicing...
2017-01-27
520 reads
Upcoming PASS Free Training
Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.
January, 2017
Tuesday,January,31
Introduction to Oracle SQL and PL...
2017-01-27
674 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers