T-SQL Tuesday 19 Disasters and Recovery
This post is my contribution to T-SQL Tuesday, hosted this month by Allen Kin (blog | twitter).
A first step in any disaster recovery...
2011-06-14
1,475 reads
Chad Miller
Tampa SharePoint Saturday 2011
I presented a 75 minute session at Tampa SharePoint Saturday on PowerShell Basics.
The presentation and demo scripts can be found...
2011-06-11
431 reads
Loading Data With Powershell
Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.
2011-05-13 (first published: 2008-12-16)
33,596 reads
Use ACE Drivers and PowerShell to Talk to Text Files
As a follow up to my SQLRally 2011 Scripting Guy Guest Blog Post which dealt with Excel and Access files,...
2011-05-10
2,336 reads
SQLRally 2011 Scripting Guy Guest Blog Post
Ed Wilson (Blog|Twitter) aka Scripting Guy has series of SQL Server related posts the week of May 2nd 2011 including...
2011-05-04
830 reads
Upcoming Events
If live in Central/South Florida or are planning a trip, we’ve got several IT community events worth checking out…
May
SQLRally in...
2011-04-08
555 reads
Tampa IT Camp 2011 Lessons Learned Part 2
In part 1 I provide an overview of concept of IT Camp, how the plan was developed by borrowing ideas...
2011-04-03
700 reads
Tampa IT Camp 2011 Lessons Learned Part 1
On Saturday, March 19th 2011 we held the first ever Saturday “code camp” style event for the IT Pro (Sys...
2011-03-30
1,744 reads
Tampa IT Camp 2011 Presentation
I presented a one hour session at Tampa IT Camp on SQL Server PowerShell Extensions (SQLPSX): “In this session we...
2011-03-20
554 reads
Restore and Relocate Database Files Using PowerShell
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
2011-03-16
2,581 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers