Finding SQL Server Installs with Powershell, Again
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
926 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
Parsing Glenn Berry’s Diagnostic Information Queries With PowerShell
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,259 reads
Finding SQL Server Installs Using Powershell
Old Dog, New Tricks
I’ve been writing tools for SQL Server for a lot of years. Some of these tools were...
2013-02-27
2,434 reads
New Toy: The Brydge iPad Keyboard – Updated
Finally a REAL keyboard for my iPad!
I can’t tell you how long I’ve wanted a real keyboard that my iPad...
2012-11-28
1,281 reads
Quick Tip: SSIS and SAP BW Round 2
Again, frustration.
After almost breaking my arm patting myself on the back getting past my last SAP BW issue I found that...
2012-11-19
1,182 reads
Quick Tip: SSIS and SAP BW
Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...
2012-11-15
3,851 reads
Solid State Storage: Enterprise State Of Affairs
Here In A Flash!
Its been a crazy last few years in the flash storage space. Things really started taking off...
2012-11-07 (first published: 2012-11-05)
2,732 reads
SSIS and Oracle All Your Non-options
Why do some things have to be so hard?
I have been asking myself that question for the better part of...
2012-11-01 (first published: 2012-10-30)
3,464 reads
The Fundamentals of Storage Systems – Shared Consolidated Storage Systems
Shared Consolidated Storage Systems – A Brief History
Hey, “Shared Consolidated Storage Systems” did you just make that up? Why yes, yes...
2012-10-30 (first published: 2012-10-26)
2,494 reads
One Great Day And Mixed Feelings
If it happens two times then you know the first time wasn’t a fluke.
Today was my anniversary date for the SQL Server...
2012-10-02
1,012 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers