Unless you are the Database Administrator or the Application Analyst for a particular database you are usually oblivious to the naming conventions of the databases that support the applications you rely upon daily. This is why it is important to have the metadata repository in place to provide that translation when the need arises.
As database professionals, we know that we are responsible for the security and integrity of the data in our systems. But Steve Jones wonders if you know what legal responsibilities you might have.
One of the less used commands in T-SQL, the UNION command can come in very handy in a number of situations. SQL Server expert trainer, Andy Warren, discusses how you can use UNION.
A SYNONYM is new to SQL Server 2005. It is a way to give an alias to an already existing or potential new object. It is just a pointer or reference, so it is not considered to be an object.
Are database professionals liable for the security of their data? Should they be? Some think so, but Steve Jones thinks this is a bad idea and we might need protection as data professionals.
Are database professionals liable for the security of their data? Should they be? Some think so, but Steve Jones thinks this is a bad idea and we might need protection as data professionals.
Are database professionals liable for the security of their data? Should they be? Some think so, but Steve Jones thinks this is a bad idea and we might need protection as data professionals.
This article illustrates how to create a simple procedure to kill many sessions at the same time, kill a range of sessions and kill all of the sessions connecting to a database.
In this video, you will learn how to use Reporting Services to build a report that contains a matrix of data.
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Jl. Arjuna Utara No.7 D-E, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah...
Jl. Dr. Muwardi I No.44, Grogol, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
Jl. Tanjung Duren Dalam III, Tj. Duren Utara, Kec. Grogol petamburan, Kota Jakarta Barat,...
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