Exporting Custom Messages from Sys.Messages
Learn how to get your custom messages from an existing instance and add them to a new instance.
Are your CPU-intensive queries running slowly? Check your VM type.
When you build a VM for SQL Server in Amazon EC2, Azure VMs, or Google Compute Engine, it’s all too easy to overlook the CPU speeds that you’re getting. Brent Ozar explains when to stop and check the VM type you used when building this VM.
Six reasons to version control your database
For application developers it is unthinkable to work without version control. Yet, only 55% of database developers are version controlling their database changes? Mary Robbins provides six reasons why you should version control your database.
Burning Out
Burning out in an IT job is easier to do than it should be. Steve has a little advice today.
Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy
Learn how you can configure clean and size management for your SSIS catalog database.
Using Parameters with Stored Procedures
It seems that SQL Server developers avoid stored procedures whenever possible, especially if they are new to the product. Kathi Kellenberger brings us a basic article that you can give to developers that explains the basics of how you use parameters with ADO.NET, especially output parameters.
Oracle for Absolute Beginners: Problem-Solving as a New Developer
Learning programming logic and syntax is just the beginning. In this article, David Njoku talks about how to debug and troubleshoot errors as a new developer.
Solving the Running Total and Ordinal Rank Problems (Rewritten)
Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.
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
Kantor BCA KCP Sumbersari Telp/wa 085169998803
Telp/wa 085169998803 Jl. Sumber Sari No.23 T 12, Babakan, Kec. Babakan Ciparay, Kota Bandung,...
Apakah UOB ada WhatsApp
Kini Anda bisa menerima info penting resmi dari UOB Indonesia melalui WhatsApp bisnis yang...
BCA KCP Mohamad Toha Telp/wa 085169998765
Telp/wa 085169998765 Jl. Moch. Toha No.197, Cigereleng, Kec. Regol, Kota Bandung, Jawa Barat 40253
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