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,677 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
833 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,031 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,369 reads
2012-10-07
856 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,608 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,321 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,522 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,385 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,310 reads
Blogs
CHOOSE’ing a Beer: #SQLNewBlogger
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Forums
SQL availability group and file server role answering from the same name
Hello, I'm tasked with setting up a 2 node server cluster that will host...
Microsoft Power BI Performance Best Practices: Learn practical techniques for building high-speed Power BI solutions Microsoft Power BI Performance Best Practices
Comments posted to this topic are about the item Microsoft Power BI Performance Best...
DbaTools With Powershell - Omit The Id Column on CSV Export?
I am learning DbaTools in Powershell, and my current project is exporting a CSV...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers