Handling Missing Instances when Looping with Pester
In my previous posts about writing your first Pester Test and looping through instances I described how you can start...
2017-11-30
691 reads
Using Common Table Expression (CTE) – Did you know…
Today I will write just a short blog post to do a quick reminder! I still hear a lot of...
2017-11-30
715 reads
SQL Server Data Tools 2017 and TFS Integration
I’ve blogged a while back on how SSIS 2017 was finally here. Not much has changed; there is still no...
2017-11-30
1,812 reads
Design Concepts For Better Power BI Reports – Part 2: Preattentive Attributes
Preattentive attributes are visual properties that we notice without using conscious effort to do so. Preattentive processes take place within 200ms...
2017-11-30
856 reads
Using Common Table Expression (CTE) - Did you know...
Today I will write just a short blog post to do a quick reminder!
I still hear a lot of people suggesting CTEs because they think it works like a...
2017-11-30
16 reads
Upgrading an expired SQL Server 2016 Evaluation Edition
It's happened to almost everyone. Someone installs Evaluation Edition and now you need to upgrade
it to a licensed copy using...
2017-11-30
898 reads
SSAS Tabular – Large Dimension Performance II
What are the limits?
What are the limits?
Of course, as a follow-up to my last article you might ask at least...
2017-11-29
152 reads
How to get started with Always Encrypted for Beginners Part 1
Encryption has always been intriguing to me but seemed like it could be a very complex process to set up....
2017-11-29
1,321 reads
Introducing SQL Operations Studio
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
707 reads
Pluralsight for Another Year
One of the ways that I try to keep current and learn is through Pluralsight. I’m lucky to get a...
2017-11-29
1,210 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