The Auto OS
Automobiles are becoming more complex, with more computerized systems every year. Steve Jones talks about some advances and how we must be sure that security is a part of future design considerations.
PASS Data Architecture VC presents James Serra on Introduction to Master Data Services
On Thursday August 20th 12PM noon Central, James Serra will discuss how companies can consolidate their enterprise data with the new feature of SQL Server 2012 Master Data Services.
SQL Server 2012 Cluster with TempDB on Local Disk
With the introduction of SQL Server 2012 Microsoft officially supports local disk TempDB in SQL Server cluster configurations. This tip will show you how to configure TempDB on a local disk when installing your SQL Server 2012 cluster.
Be Careful Using LiteSpeed Extended Stored Procedures With SQL Agent
It’s uncommon that a SQL Server DBA needs to create a customized backup and restore routine for an application using combination of LiteSpeed extended stored procedures. However, you should be really careful when you are implementing such a solution.
Those Who Can, Do
Does certification help your career? Is it the choice for those that can't actually accomplish something in the real world? Steve Jones says that it can go either way, but it's up to the individual.
How do you develop software?
We’d like to learn more about software development at your company. Complete our 5 minute survey and get a chance at winning a $50 Amazon gift certificate.
Report Builder 3.0: Adding Matrices to Your Reports
It is easy to create a basic matrix in Report Builder. However, it takes some practice in order to format and dispay the matrix exactly how you want it. There are a large number of options available to enhance the matrix and Robert Sheldon provides enough information to get you the point where you can experiment easily.
Holidays and other Social Technologies
A look at what passes for technology from Bill Nicolich in our guest editorial.
MDX Guide for SQL Folks: Part II - Hierarchies and Functions
Learn everything about MDX by drawing only on your SQL knowledge.
Version Control with Integration Services
Thie article focuses on using SSIS to automatically check in the changes that the developers missed for the day into the version control system.
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 Yos Sudarso TLP/WA (08216977749)
Jl. Yos Sudarso No. 50, RT 009 RW 02. Kel. Melayu, Pasiran, Kec. Singkawang...
BCA KCP Pasar Kebayoran Lama Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran Lama, Kota Jakarta Selatan, Daerah...
BCA KCP Sanggau TLP/WhatsApp 08216977749
Jl. Jenderal Ahmad Yani No.22, RT.03/RW.01, Ilir Kota, Kec. Kapuas, Kabupaten Sanggau, Kalimantan Barat...
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