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
751 reads
Blog Posts
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
972 reads
Summit 2014 – Early Impressions
Summit 2014 is upon us. Unless you are still under a rock, you probably know that. And if you are under that rock, I am curious how you are...
2014-11-06
1 reads
Summit 2014 – Early Impressions
Summit 2014 is upon us. Unless you are still under a rock, you probably know that. And if you are...
2014-11-06
578 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
50 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
7 reads
VM Right-Sizing PASS 2014 Session Wrap Up
Today I presented my SQL Server virtual machine “right-sizing” session at the SQL PASS 2014 Summit to a fantastic audience....
2014-11-06
565 reads
#SQLPASS #Summit14 Day 1 Keynote Highlights !
PASS President Thomas LaRock on stage !
PASS President Thomas LaRock kicked off the summit keynote.
Tom talked about the history of...
2014-11-05
876 reads
Book: Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
I was fortunate to be a technical reviewer for a new book, SQL Server 2014 Business Intelligence Development by Reza...
2014-11-05
1,973 reads
Find all triggers in a SQL Server Database
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce business rules or...
2014-11-05 (first published: 2014-10-24)
22,704 reads
Blogs
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Forums
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers