Award from MSSQLTIPS.com
Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.
I have...
2015-01-14
687 reads
Blog Posts
Excel 2013 Conditional Formatting for Columns
If you have two columns in an Excel sheet, and you want to conditionally format fields in the second column...
2015-01-14
777 reads
Execute the Current Statement–SQL Prompt
This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which...
2015-01-14
1,281 reads
HOWTO: Filter Dacpac Deployments
Updated 2015-02-02 I have changed the details about passing multiple filters at the bottom, see the codepex site for full...
2015-01-14
75 reads
HOWTO: Filter Dacpac Deployments
Updated 2015-02-02 I have changed the details about passing multiple filters at the bottom, see the codepex site for full...
2015-01-14
1,241 reads
HOWTO: Filter Dacpac Deployments
Updated 2015-02-02 I have changed the details about passing multiple filters at the bottom, see the codepex site for full details.
tldr; Download the filter from: https://agilesqlclub.codeplex.com/releases/view/610727 put the dll...
2015-01-14
54 reads
Power BI Designer and Power BI Dashboard
Long has the question been asked “Which Microsoft tool do I use for dashboards?”. SSRS, Excel, PowerView, Report Builder and PerformancePoint...
2015-01-14
2,284 reads
T-SQL to Display Weekends Between two Dates
Different ways to find the weekend between two given dates. The SQL requires @begindate and @endate paramteters to be entered...
2015-01-14
1,048 reads
VMware Online Event – February 2nd
VMware has recently announced an online event for February 2nd that you don’t want to miss! Whatever it is, it’s going...
2015-01-14
576 reads
Author of the Year at MSSQLTips.com
I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at...
2015-01-13
519 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
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