Querying Oracle from Powershell Part 1
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
Querying Oracle from Powershell Part 2
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
Using The Data Mining Query Task in SSIS
The Data Mining Query Task can be used to run prediction queries based on data mining models built in analysis service.
A SQL Evening in London
Spend an evening with Itzik Ben-Gan, Greg Low, Davide Mauri and Bill Vaughn in London on March 16th. Come attend if you can.
Fixing DBCC CHECKDB Msg 8992 Errors
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
Usage Based Pricing
Software pricing is a controversial topic, but Steve Jones found an article saying many enterprises would prefer usage based pricing. Do you think it's better?
Efficiently Reuse Gaps in an Identity Column
This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.
How Do You Drive Your DBA Mad?
I’ve written about a few ‘worst practices’ over the years to call attention to some things that are bad (or...
March Question: What is the biggest mistake/problem you have ever found on a SQL Server instance, and how did you fix it?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
SQL Saturday #33
A one day training event in the Charlotte, NC area. Come join MVPs from around the area at another great SQL Saturday.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Pasar Cibinong TLP/WA 08216366654
Ruko Mayor Oking Blok B. 1, Jl. Mayor Oking No. 35, RT 002/001, Cirimekar,...
BCA KCU GAJAH MADA Telpon/WA.0853•5504•2311
BCA KCU GAJAH MADA Telpon/WA.0853•5504•2311 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman...
BCA KCP Lodan Center Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 LODAN CENTER, Ruko Jl No.6-7 Blok O, Ancol, Kec. Pademangan, Jkt Utara, Daerah...
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers