Database administrator with 14+ years of hands-on experience in database management and database design. After spending 15 years as a SQL Server DBA, I've witnessed numerous technological evolutions, ...
Below is a cheat sheet that can be used for configuring SQL Server audit policies to log and detect potentially malicious behavior. It also includes some TSQL cheats for viewing the current audit ...
SELECT @cpu_time_start = cpu_time, @elapsed_time_start = total_elapsed_time FROM sys.dm_exec_sessions WHERE session_id = @@SPID IF OBJECT_ID ('tempdb.dbo.#tmp_requests') IS NOT NULL DROP TABLE ...
A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
Your browser does not support the audio element. This tutorial is made for everyone who wants to learn ASP.NET Core and ADO.NET quickly. All the things are explained ...
Leveraging Microsoft SQL Server, we have made it easier for app makers to enable their users to take pictures and upload files in their apps. App makers can now use the Microsoft SQL Server connector ...
This blog post was co-authored by Joseph Sirosh, Corporate Vice President, and Rimma V. Nehme, Principal Software Engineer, at the Data Group at Microsoft. Figure 1: Visible objects of the Sloan ...
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. We may earn ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results