IT People’s Technical Debt and Reputation Credit
In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do...
2016-06-08 (first published: 2016-06-01)
2,017 reads
PowerShell – Deleting those files
Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...
2016-06-01
182 reads
What is the max/min size of a decimal data type?
Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and...
2016-05-31
1,180 reads
“Tuesday Morning” SQL Break – May 31, 2016
Yesterday it was Monday, which is when I usually aim to post a weekly blog and twitter round-up. But since I...
2016-05-31
847 reads
Running Multiple Threads Quickly
Recently I was looking to generate a quick workload against an instance. I wanted to add to the amount of...
2016-05-31
1,052 reads
Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS
[2016-May-31] Two different metrics, two different datasets, one may represent a very high value and the other one is very low....
2016-05-31
1,705 reads
THE SQL Server 2016 NYC Launch Event Schedule
Presenting the OFFICIAL SQL Server 2016 NYC Launch Event Schedule for Thursday, June 2, 2016, just ONE day after the...
2016-05-31
1,966 reads
Precedence Goes to Query Store or Plan Guide?
While presenting at SQLDay in Wroclaw, Poland, on the Query Store, I was asked a pretty simple question, which takes...
2016-05-31
943 reads
Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc
*Update: The Power BI team has finally published a blog post with all the new features and its glorious! Read...
2016-05-31
1,319 reads
I hate saying no
I really do. There is a joke that DBAs say no to everything and there is some truth to that....
2016-05-31
755 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers