Uncategorized

Wonder ever using extended events for capturing deadlocks and blocking in your SQL read it now … Good document for implementing such using service broker and capturing using extended events…. Click to access wpd-sql-extevtandnotif-us-sw-01112012_1.pdf

Its a good read for quick reference about implementing DR for multiple services with in SQL Server ( User DB , SSRS , SSIS , SSAS ). https://blogs.technet.microsoft.com/ptsblog/2014/01/28/sla-and-disaster-recovery-planning-for-microsoft-business-intelligence/  

Today morning when I installed 2016 CTE3 over 2012 as a separate instance and tried connecting but failed with errors then thought of do some research work of ways to figure out what happened to me if forgot to remember instance names given. it happens always with me… then this handy document can help many…

Hello , If you already don’t know this . https://technet.microsoft.com/en-us/library/Hh831724.aspx

Vulnerability Affecting All Supported Versions of SQL Server Well,SQL Server hasn’t had a security update since August, but today we’re giving the hotfix download servers a run for their money. Both GDR and QFE fixes were released in Security Bulletin MS15-058, to address a vulnerability in remote code execution (for details on the exploit, see KB #3065718).The…

Originally posted on IT Developer Zone: Collation in SQL Server: http://ow.ly/OTflE

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.…

Ongoing Windows Perfmon Collection Setup Performance statistics are critically vital for the long-term health and capacity management of an enterprise environment. Unless a third-party performance statistics collection utility, such as Microsoft System Center, is already in place in an environment, Perfmon on each Windows Server can be configured to constantly record performance statistics for future…

These the very real best practices every DBA should follow. I am sharing one the very interesting and very useful blog post by experts in PCI compliance and who adhere to apply all those securities. There are some general principles which provide guidelines on how to achieve and maintain PCI DSS security. Create an SQL…

Here is the useful information.If you do not have physical access to your Database but want to get the hardware information of your SQL Server, use this query: SELECT cpu_count AS [Logical CPUs], hyperthread_ratio AS [Logical vs Physical cores Ratio], physical_memory_kb/1024 AS [Physical Memory in MB], committed_kb/1024 AS [Committed Memory in MB], committed_target_kb/1024 AS [Committed…