Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022
The...
2013-03-13
196 reads
Aaron Nelson
Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022 The day before the event Atlanta MDF is...
2013-03-13
10 reads
2013 North American PowerShell Summit
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday April 24th at the Microsoft campus in Redmond,...
2012-09-25
8 reads
2013 North American PowerShell Summit
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday...
2012-09-25
1,171 reads
Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012
Atlanta MDF presents:
SQL Saturday #111 Pre-Conference Sessions
SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve...
2012-02-03 (first published: 2012-02-01)
1,597 reads
Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012
Atlanta MDF presents: SQL Saturday #111 Pre-Conference Sessions SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve managed to schedule 3 awesome pre-con sessions...
2012-02-01
7 reads
Day Zero with PowerShell
Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server.
2012-01-02 (first published: 2011-05-10)
15,845 reads
Finding Free Space per Data File with PowerShell
Learn the easy way, and the hard way, to find the free space in each data file with Powershell expert Aaron Nelson.
2011-05-11
6,449 reads
PowerShell takes the Pole at SQLRally!
PowerShell takes the Pole at SQLRally!
PowerShell has taken the Pole for the DBA division at SQLRally! Come see why the...
2011-05-10
713 reads
Late April Free Training from PASS VCs
PowerShell provisioning of Hyper-V Servers
Designing Cubes for Performance
Database Standards SOP
_____________________________________________________________
PowerShell provisioning of Hyper-V Servers
April 20, 2011, 12 PM EDT (GMT...
2011-04-15
709 reads
Blogs
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Forums
Alamat kontak resmi BCA KCP Buaran Raya Telp:0817866887
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
Alamat kontak resmi BCA KCU BUKIT BARISAN Telp:0817866887
WhatsApp:0817866887 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
Alamat kontak resmi BCA KCU BUKITTINGGI Telp:0817866887
WhatsApp:0817866887 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi, Sumatera...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers