Checking SQL Server Services Owner
Not only is the DBA responsible for the running status of the Services, they are responsible that the Service is running with a proper owner.
Win a Collection of SQL and .NET Books. And a Bookshelf
After winning a number of awards for our software, Red Gate is giving away books to 300 people as a celebration.
Better Licensing for SQL Server
Why is SQL Server licensing so complex? Today Steve Jones asks the question and wonders if Microsoft would make some changes to make it easier to understand.
Parent Package Variable Configuration and Logging
In SSIS, when we use 'parent package variable configuration' the order of event execution is quite different than the normal execution order. In this article we will see what the impact on execution order when we use 'parent package variable configuration'.
QlikView for Beginners - An Introduction to QlikView
A brief introduction to getting started with QlikView.
Coping with Infrastructure Upgrades
A common topic for questions on SQL Server forums is how to plan and implement upgrades to SQL Server. Moving from old to new hardware or moving from one version of SQL Server to another. There are other circumstances where upgrades of other systems affect SQL Server DBAs.
Deployment Failures
Today Steve Jones talks about deployment and how well it can work. He also asks about the problems from you and how easily it can fail.
Disaster In The Real World - #2
Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.
Disaster Recovery Week
This week we highlight the practice of being prepared for disasters at SQLServerCentral.
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