SQL Server Monitoring Scripts with the DMVs
If you do not have a third party monitoring tool in place, the only way is to constantly monitor SQL Server. To do this without being overly intrusive, we need to rely on the SQL Server DMVs.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
Getting started with SQL Azure
The cloud services from Microsoft for SQL Server are known as SQL Azure. MVP Jacob Sebastian brings us a introductory article about how to work with this service.
Top Ten Reasons to Attend the 2009 PASS Community Summit
There are some good reasons to think about attending the 2009 PASS Community Summit.
What Do We Want from PASS?
With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.
Calling Stored Procedures from .NET Applications
Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored procedures used to their full advantage in database applications? William Brewer goes through some of the basics, but uses PowerShell as the example .NET application, and avoids all mention of Northwind or AdventureWorks!
SQL Server Configuration
The importance of correct configuration. Which default configuration options to change. Common mistakes.
Transparency and PASS
I hate to start a blog war, but maybe there's one going on. The recent PASS 2009 election concluded a...
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 Batu Ceper Hub/Wa 08216977701
Jl. Batu Ceper No.18 A-B, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Metro Pasar Baru HUB/CS 08216977701
Metro Ps. Baru, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Gedung, Kecamatan Sawah...
BCA KCP Prima Sunter Hub/Wa 08216977701
Jl. Danau Sunter Utara No.A2-A3, Sunter Jaya, Kec. Tj. Priok, Jkt Utara, Daerah Khusus...
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