Starting and Stopping a Remote Service with PowerShell
A recent project I was working on required me to move folders from a staging location to a processing location....
2011-07-18
1,939 reads
Tim Radney - Database Professional
My first PowerShell Script to Move Folders
I just had my first encounter with having to write a PowerShell script. The request seemed pretty harmless when I...
2011-07-15
1,937 reads
SQL Saturday 89 Pre-Con
Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89...
2011-07-14
603 reads
Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked...
2011-07-04
731 reads
Planning a SQL Saturday
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted...
2011-07-01
416 reads
Getting Ahead and Getting Involved
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question...
2011-06-28
861 reads
SQL Saturday #89 Atlanta GA
The official launch of SQL Saturday #89 was June 8th. Within the first week of the launch we have registered...
2011-06-15
496 reads
Using “NOT IN” in a query can provide mixed results
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A...
2011-05-31
1,363 reads
Using an Excel Destination in SSIS with x64
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL...
2011-05-17
1,113 reads
SQL Saturday 74 – Jacksonville FL
I made a 700+ mile round trip down to Jacksonville FL where I was fortunate enough to get to speak...
2011-05-02
874 reads
Blogs
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Creating a Flyway Desktop Shadow Database in PostgreSQL
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
Daily Coping 6 Feb 2023
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
Forums
Extended Events shows each SQL command in one long line
Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...
Group by issue
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...
Ownership chaining
Hi, I have four views on one database to which one sql authenticated user...
Ask SSC