PowerShell – List Local or Remote Programs with an Exclusion List of Programs
This post is to list all the software installed on your local or remote machines. The exclusion list is an...
2013-09-16
1,269 reads
Blog Posts
SQL Saturday #191 Kansas City was Great
This past weekend I presented a preview of my SQL PASS Summit spotlight session entitled “Squeezing Top Performance From Your...
2013-09-16
582 reads
SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time
Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...
2013-09-16
495 reads
SQL SERVER 2012 - How to get a value from previous result row effectively
Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...
2013-09-16
695 reads
SQLSaturday #250 Pittsburgh
SQLSaturday #250 Pittsburgh is in the books, and I'd like to sincerely thank the organizers, sponsors, volunteers, and speakers for...
2013-09-16
474 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
736 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
387 reads
Order of a Result Set in SQL
I have seen people build procedures that rely on a result set being returned in a certain order. This is...
2013-09-14
750 reads
Are Foreign Keys Better Than Indexes?
When I first saw this question I thought to myself, “Self. Don’t you think that’s comparing apples to hammers? Yes,...
2013-09-13
906 reads
Colorado SQL Events : September 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-09-13
530 reads
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Online Marketing Service
Not sure where to start with online marketing? Our online marketing service eliminates guesses....
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers