Why Use Red Gate’s SQL Multi Script?
Someone once told me at the shop that we have plenty of software utilities laying around that could be very...
2017-01-18
522 reads
Blog Posts
Getting My Alias in #SQLPrompt
I got a tweet after my SQL Prompt formatting piece that said a user would be interested in upgrading from...
2017-01-17
537 reads
Joint OPASS/MagicPASS Meeting Tomorrow Night (January 18, 2017)
Grant Fritchey will be presenting Faster Provisioning with SQL Clone and Denny Cherry is presenting Optimizing SQL Server Performance in...
2017-01-17
443 reads
Present Like Nobody's Watching
Last week I presented my session High Performance SSRS at the inaugural GroupBy Conference. It was an incredibly fun experience getting to present a topic I'm excited about as...
2017-01-17
6 reads
Publish Power BI Reports to SSRS On-premise Preview Now Available
This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical...
2017-01-17
676 reads
SQL Saturday 582 Melbourne (11 Feb 2017) and Ignite 2017 (14-17 Feb 2017)
For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast…
SQL Saturday582 (Sat...
2017-01-17
553 reads
SQL Saturday 582 Melbourne (11 Feb 2017) and Ignite 2017 (14-17 Feb 2017)
For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast… SQL Saturday 582 (Sat 11 Feb 2017). Melbourne. For those looking for...
2017-01-17
4 reads
Team Collaboration with Microsoft OneNote – #TAPtips
I was an early adopter of Microsoft’s OneNote and started using it in February of 2004 and have never stopped....
2017-01-17
395 reads
Understanding Network Latency and Impact on Availability Group Replication
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction...
2017-01-17 (first published: 2017-01-06)
3,069 reads
Upcoming Class: Building Better SSIS Packages in Pensacola
I’ll be teaching my popular day-long course, Building Better SSIS Packages, on Thursday, June 1 in Pensacola, Florida. This class...
2017-01-17
368 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers