What to Expect When Transitioning from DBA to Consultant
Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning...
2015-01-15
570 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
Part2 Adding a New CheckBox – Create your own SQL tools with PowerShell and Windows forms
Steve:
This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for...
2015-01-19 (first published: 2015-01-14)
6,787 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
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
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
Common Table Expressions Are Not Tables
There’s power in naming things. Supposedly some types of magic are even based on knowing the correct names for things....
2015-01-20 (first published: 2015-01-14)
8,485 reads
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
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
325 reads
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
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