Awarded – Microsoft Community Contributor Award 2012
Today, I’ve received an email from Microsoft stating that I’ve been awarded Microsoft Community Contributor. This is the first time...
2012-10-18
1,684 reads
Basit Aalishan Masood-Al-Farooq
How to secure SQL Server?
Databases are an important reservoir of sensitive information, and that is why it is important for us as a DBA...
2012-10-15
845 reads
Using SQL Server 2012 FileTables
Reblogged from Basit's SQL Server Tips:
SQL Server 2012 allows you to store file/directories in a special table called FileTable that...
2012-10-15
1,035 reads
Understanding DBCC CHECKDB, to deal with corrupt database
Database files are volatile, constantly being changed and updated, so that, like any other volatile files in the system, there...
2012-10-08
1,378 reads
2012-10-07
860 reads
Rebuild indexes based on fragmentation - sp_RebuildIndex
Reblogged from Basit's SQL Server Tips:
In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server...
2012-10-07
1,626 reads
DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events
SQL Server Agent jobs are crucial to any SQL Server environment, as they are used for scheduling and performing critical...
2012-10-01
1,338 reads
Transact-SQL analytic functions in SQL Server can help solve problems quickly
Like other mainstream commercial database systems, SQL Server supports analytic functions in Transact-SQL to depict complex analytical tasks. With the...
2012-09-21
1,530 reads
Database Recovery Advisor feature of SQL Server 2012
SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases...
2012-09-19
2,389 reads
Logon Triggers: SQL Server
As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...
2012-09-17
24,338 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers