Git Push in SQL Source Control
I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...
2015-10-22
1,948 reads
Blog Posts
Histograms and Events
In this article I show how to use and configure the histogram target. In addition, I explain how to get to the data trapped into this target. Lastly, I...
2015-10-22
7 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
21 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
23 reads
Step by Step SSIS–Derived Column Transformation TIP # 120
Dear Friends,
In the series of Step by Step SSIS , Zero to Hero in SSIS this is another post in which...
2015-10-22 (first published: 2015-10-18)
2,510 reads
Working with “special” names
What do you do when you need to use a special character in a name? Well, I guess I should...
2015-10-22 (first published: 2015-10-19)
1,506 reads
ZOOMIT!
Guilty.
I’m at least one of the people who yelled Zoomit during a keynote at PASS Summit.
I want to take a moment...
2015-10-22
566 reads
10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-10-21
477 reads
Consequences of Timeout/Error on a Delete statement
Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...
2015-10-21
455 reads
Goodness-of-Fit Testing with SQL Server, part 1: The Simplest Methods
By Steve Bolton
…………In the last series of mistutorials I published in this amateur SQL Server blog, the outlier detection methods...
2015-10-21 (first published: 2015-10-17)
2,515 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