I’m Speaking at the SSWUG VConference in April
Hey All ! I wanted to let you know I will be speaking at the SSWUG Virtual Conference this Spring. This...
2010-02-20
221 reads
Pragmatic Works is on YouTube !
I bet you didn’t know Pragmatic Works has our own YouTube channel ? Check it out at
There is some great...
2010-02-20
286 reads
Don’t Miss our Upcoming Webinar Series in February and March
More awesome happenings from Pragmatic Works, Wrox, and SQLServerCentral.com. Check out our Upcoming Webinar Series next week. They are free,...
2010-02-20
257 reads
Using MDX to work with the File System
There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...
2010-02-20
402 reads
Important SSAS Dimension Properties
When configuring a SSAS Dimension, there are many important properties to pay attention to. This blog will give you a...
2010-02-20
454 reads
Why don’t lookup columns appear in no match output?
I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...
2010-02-20
358 reads
Improve your SSMS Interaction
Ever wanted to liven up your life some with some color in your day to day DBA duties. There are...
2010-02-20
254 reads
LastPeriods and PeriodstoDate
There are several ways for calculating “To-Date” calculations the longer way. These normally include a more granular level of control...
2010-02-20
607 reads
MDX Time Calculation Shortcuts
There are lots of ways to calculate time comparisons in MDX, but there are some great shortcuts. The functions WTD,...
2010-02-20
296 reads
Connecting to DB2 AS\400 with SSIS
We have a lot of projects in our organizations that require us to work with database systems other than SQL...
2010-02-20
4,514 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers