Learning Powershell
I’ve been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my blog you might be aware...
2010-06-23
1,705 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Sarasota SQL Server Users Group
Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...
2010-06-15
710 reads
Virtualizing Servers in Production
The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...
2010-06-15
863 reads
Maps in Reports!
I’ve been playing with SQL Server 2008 R2 for quite a while in the CTP’s and what not. But, I hadn’t made...
2010-06-14
1,221 reads
I’m a Pain
Or maybe I’m misreading that I’m supposed to be helping to alleviate pain. Either way, next Thursday, June 17, I’ll be...
2010-06-10
553 reads
PASS 2010 Submissions
Since all the cool kids seem to be posting the sessions that they submitted to the PASS Summit, nerd that...
2010-06-09
804 reads
Buy vs. Build
It’s the classic question faced by everyone in Information Services. I know how to do this and I could build...
2010-05-28
1,597 reads
Slick New Software
I’m lazy. And frankly, I’m not ashamed to admit it. When a software comes along that can do the work...
2010-05-24
1,280 reads
Free Advice or Free Consulting
A guest editorial from Grant Fritchey today talks examines the free advice that is often given in the forums. It's not free consulting and you shouldn't expect that.
2010-05-13
272 reads
Recompiles and Constant Learning
When faced with a procedure that looks like this:
CREATE PROCEDURE dbo.TestProc (@TestValue INT)
AS
BEGIN
IF @TestValue = 1
BEGIN
SELECT *
FROM Sales.SalesOrderHeader AS soh
JOIN Sales.SalesOrderDetail...
2010-05-11
771 reads
Blogs
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
A Note and a Message: T-SQL Tuesday #193
By Steve Jones
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...
Forums
This doesn't make sense to me - making me crazy - er
Hi So I have the below select query that won't return results if I...
Catalog max connection pool size: 100
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers