In the immortal words of “Orange” Julius Caesar as written by Shake’s peer, “Beware the bugs of March.” It took us 2,064 years, but we’ve finally fixed those bugs, plus added a couple of new features.
The purpose of this document is to walkthrough helpful Unix commands that would help use Unix/Linux operating system, debug & resolve any issues in a more efficient and timely manner.
In this tip I will demonstrate a simple way of launching a SQL Agent job when the job it depends on completes successfully.
The State of Database Monitoring survey is open. How are you currently monitoring your database estate? Are you working cross-platform? Tell us your opinions in our annual survey on the State of Database Monitoring for your chance to win a $500 Amazon voucher.
Take the survey.
Fingerprints provide some security, but a research suggests not necessarily much. Steve has a few thoughts.
No matter where you run your SQL Server® instances—on-premises, in a virtual machine, or in an Azure SQL Database Managed instance—the challenge is the same. How do you ensure you get optimum performance? Is the virtual machine impacting your database instance performance? Which queries cause the most blocking or deadlocking? Are you consuming more DTUs in your Azure SQL Database than you budgeted for?
Running software teams isn't as easy as it may seem, and the way you manage a startup is different than a mature organization. Steve has a few comments on the process one angel investor implements.
SQL Monitor 10.0.5 now supports a user role called "Reports user". A user added to this role, by an administrator, will be able to 'self-serve' SQL Monitor reports but won't be able to configure any other aspect of the monitoring service. Jeremiah Peschka explains how it works.
While Microsoft provides a number of different deployment options for its Azure SQL Database offerings, one in particular warrants special attention from the standpoint of its infrastructure dependencies: Azure SQL Database Managed Instance.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
We have a SQL Server installed. We have a 500GB drive for the database....
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers