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,476 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
433 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,338 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
831 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,745 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
557 reads
To Script or Not To Script
When approaching an automation problem the first questions you must answer is whether you should even invest the time to...
2011-03-15
694 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-14
7,969 reads
Blogs
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
Forums
Even When You Know What You're Doing, You Can Screw Up
Comments posted to this topic are about the item Even When You Know What...
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers