Monday Morning Mistakes: Connecting to Wrong Environments
Today’s Monday Morning Mistake issue is another painfully common one that we all run into at some point. You’ve got...
2012-06-18
2,323 reads
sqlchicken
BIxPress 3.5–Now With More Awesome!
Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a...
2012-05-21
1,187 reads
SQL Server 2012: Biggest Little Core-house
You sure do got a 'purty motherboard...
Now that SQL Server 2012 is generally available to the public, many companies are...
2012-04-30
2,974 reads
Pragmatic Works Software for MVPs
This is just a quick post to remind folks who are current Microsoft MVPs that Pragmatic Works offers NFR licenses...
2012-04-23
1,092 reads
STOP! Consolidate and Listen
I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance,...
2012-03-21
910 reads
Monday Morning Mistakes: Not Setting Memory Limits
Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite...
2012-03-12 (first published: 2012-02-28)
42,453 reads
Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly
SSIS Expressions
Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables,...
2012-02-16 (first published: 2012-02-13)
4,215 reads
Monday Morning Mistakes: Remote Connectivity to SQL Server
Inspired by common emails and questions I see, I figured I’d do a series of blog posts on common mistakes...
2012-01-23
992 reads
Estimated Completion Time for Backups and Restores
I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...
2012-01-03 (first published: 2011-12-30)
79,996 reads
SQL University: Virtualization Basics
This week we’re going to talk about a topic that has been gaining steam in the last few years and...
2011-11-17
1,165 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