SQL Server 2008 Administration in Action - Sample Chapter
A sample chapter on clustering from Manning Publishing. Read it to learn a bit on clustering and preview this new book.
Defining a Database
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
Defining a Database
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
Defining a Database
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
Holidays and Parties, Gift, Expectations, and Wishes
Most companies do something at the holidays, although it seems to be less with each year, and certainly this holiday...
Understanding SQL Server fixed database roles
I know there are fixed database roles that come with SQL Server. How do I best use them within my installations? What should I watch out for? In this tip we will cover each of the database roles and recommendations on when to and when not to use them.
Yes, Table Variables and Temp Tables both use the tempdb
Pinal Dave recently wrote a blog post called SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth...
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Dissecting SQL Server Execution Plans
A review of MVP Grant Fritchey's "Dissecting Execution Plans". This is one book that you'll want on your bookshelf.
Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail
Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.
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 Saharjo Hub.0851•8812•0691
BCA KCP Saharjo Hub.0851•8812•0691 Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota...
BCA KCP Santa Hub.0853•5504•2311
BCA KCP Santa Hub.0853•5504•2311 Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta...
BCA KCU SUDIRMAN Hub.0853•5504•2311
BCA KCU SUDIRMAN Hub.0853•5504•2311 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi,...
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