PowerShell- Monitor Group Of Services on ‘N’ Servers & Notify Stopped Services
This post explains how to monitor a multiple services on a list of servers and send alert when the given...
2014-11-06
763 reads
PASS Summit 2014: WIT Luncheon
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
630 reads
PASS Keynote–Dr. Rimma Nehme
I missed the PASS welcome, but I did arrive to see Cloud Databases from Dr. Rimma Nehme.
We begin with a...
2014-11-10 (first published: 2014-11-06)
5,335 reads
Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine know “hey, here’s the fast way to get directly...
2014-11-06
22 reads
Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine know “hey, here’s the fast way to get directly...
2014-11-06
66 reads
Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine...
2014-11-11 (first published: 2014-11-06)
7,423 reads
PASS Summit 2014 Day 2 Keynote Live Blog
We are back in the keynote room with Adam Jorgensen talking to us about the financial state and health of...
2014-11-06
417 reads
Questions for the Board Q&A
Each year for the past few years the PASS Board of Directors has conducted a Q&A session with members at...
2014-11-06
988 reads
Generalists vs. Specialists
I’ve stated quite often that being a generalist has generally been beneficial for my IT career (pun intended). That’s why...
2014-11-13 (first published: 2014-11-06)
7,249 reads
Configuring a Complete Memory Dump
Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform...
2014-11-06
1,995 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers