Sitemap
Pages
- About Us
- Azure SQL Support
- Contact
- FAQs
- Home – New
- Home Version2
- Managed SQL Server Support
- News
- Privacy Policy
- Services
- SQL Server Consultancy Services
- SQL Server Emergency Support
- SQL Server Health Checks
- SQL Server Monitoring
- SQL Server Performance Tuning
- SQL Server Support & Remote DBA Service
- Terms & Conditions
- Test Page
Posts by category
- Category: Blog
- How Does Microsoft Copilot Help with SQL Query Optimisation?
- Essential Security Updates for SQL Server Versions 2016 to 2022
- SQL Server 2022 CU14: Key Updates and Enhancements
- “SQL Server 2022 CU14: Key Updates and Enhancements”
- Critical Security Patch: Preventing Remote Code Execution Vulnerabilities
- Critical Security Patch: Preventing Remote Code Execution
- SQL Server 2019 CU27: Latest Updates and Enhancements
- “Latest Updates: SQL Server 2019 CU21 and 2022 CU5 Released”
- SQL Server Performance Tuning: Best Practices for Developers
- “SQL Server 2022: Rapid-Fire Updates Enhance Performance and Security”
- “SQL Server 2022’s First Update and Enhancements for Previous Versions”
- Update all DB growth parameters to defined increments
- Microsoft’s Postponement of Patches: Investigating Incorrect Results Bugs in SQL Server 2019 and 2016
- Critical Security Issue in Extended Events Fixed in Latest SQL Server Updates
- The Uncertainty Continues: Microsoft Releases SQL Server 2019 CU8 Amidst Ongoing Issues with Update Documentation
- Assessing SQL Server 2017 Cumulative Update 22: A Frustrating Lack of Documentation
- Microsoft Releases Cumulative Update 7 for SQL Server 2019, Including Important Fixes.. BUT…
- SQL Server 2019 Cumulative Update 6: Important Fixes with Limited Documentation
- SQL Server 2019 Cumulative Update 5: Important Fixes and Limited Documentation
- SQL Server 2017 Celebrates 20 Years with New Cumulative Update 20
- SQL Server 2019 Cumulative Update 4: Fixes and Enhancements for Better Performance
- SQL Server 2016 SP2 Cumulative Update 12: Fixes and New Features for Better Performance and Stability
- SQL Server 2019 Cumulative Update 2: Bug Fixes and a Warning
- SQL Server 2017 Cumulative Update 19: The Latest Fixes and Improvements
- Get the Latest Bug Fixes and Enhancements with SQL Server 2019 Cumulative Update 1
- Boost Your SQL Server Performance with the Latest Cumulative Updates: SQL Server 2017 CU18 and SQL Server 2016 SP2 CU11
- Enhance Your SQL Server 2016 Performance and Security with Cumulative Update 9 – HOLD
- SQL Server 2016 SP2 CU8: A Must-Have Update for Improved Performance and Security
- Stay Ahead of the Game with SQL Server 2014 SP3 CU4: The Latest Cumulative Update for Improved Performance and Security
- New Updates for SQL Server 2017 and SQL Server 2016 SP2: CU15 and CU7 for Improved Stability and Security
- SQL Server 2017 Analysis Services Security Update: Addressing Vulnerabilities to Ensure System Security
- New Updates Released for SQL Server 2014 SP3 and SP2: CU3 and CU17 for Improved Stability and Security
- Why is the SQL Server So Slow?
- 10 Things Every Project Manager Must Know When Deploying a SQL Server
- How to Configure SQL Server Auditing
- The Benefits of Outsourcing SQL Database Management
- Uncover Missing Indexes with DMV
- How to Find SQL Logins with NO Database Mappings
- How to Grant Read-Only Access to Activity Monitors
- Be Mindful of Deprecated Features in SQL Servers
- Recompile All SQL Server Stored Procedures with this Script
- Find the SQL Server Product Key with the Right Script
- How to Resolve an Agent XPs Disabled Error
- Add these 5 Must-Have DMV Queries to your DBA Toolbelt!
- How to Check Fragmentation Level of a Database
- How to update DB File Growth Settings for ALL Databases at the same time
- How to Fix Very Large MSDB Database
- How Healthy is your SQL Server?
- Surround Yourself with Smart People
- Reasons Given for NOT Hiring an External DBA − And Why You Should Reconsider
- When’s the Last Time you Serviced your SQL Servers?
- Gettin’ Techie SET STATISTICS TIME
- Category: SQL Server 2005
- Category: SQL Server 2008
- Category: SQL Server 2012
- Category: SQL Server General
- Stay Up-to-Date with SQL Server 2017: Announcing Cumulative Update 14 with Notable Enhancements and Important Security Updates
- SQL Server 2016 SP2 CU6: The Update with Significant Changes and Important Security Updates
- New Updates Released for SQL Server 2014 SP3 and SP2: CU2 and CU16
- New Updates Released for SQL Server 2016 SP2 and SP1: CU5 and CU13
- SQL Server 2000 Health Check Script in CVS
- Script: Query Full Table Scans via the Search Cached Plans’ DMV
- Identify Performance Bottlenecks with SQL 2005 and 2008 Perfmon Counters
- How to Fix Orphaned Users on an SQL Server
- How to Set Up Mirroring in a Workgroup Using Certificate Authentication
- How to Emulate an SQL Cluster Using Mirroring
- How to Set up DB Mirroring using T-SQL
- How to Fix Performance Dashboards for SQL 2008
- How to List the Database Name and File Locations
- SQL Server DMV Query to Output Index Fragmentation by Database / Table
- How to Remove Replication Monitor Red Crosses
- How to Resolve the SSIS Subsystem That Failed to Load
- How to Enable xp_cmdshell Using sp_configure and Run Batch File from xp_cmdshell
- How to Set up an SQL Server Alias Name
- How to Dynamically Backup and Compress User Databases (SQL 2008)
- A Visual Explanation of SQL Joins
- Format drives with correct allocation and offset for maximum SQL Server performance
- How to Resolve Database Restore Operation-Related Errors
- How to create a DDL Trigger to notify on New Database Creation
- How to Speed up SQL Management Studio
- Synchronous Database Mirroring (High-Safety Mode)
- Transfer / Migrate users between versions of SQL Server
- Return Top 50 Queries by Average CPU
- How to create a SQL Server Database Snapshot
- Script to change ALL Database Objects back to dbo
- How to Attach a Database with No Log File
- How to Kill all Database Connections
- How to Search every Table in a SQL Database for a String
- How to update all objects in a table to DBO
- How to Check Authentication Method into SQL Server (SharePoint)
- PCI Compliance Requirements with SQL Server
- SQL Server Migration Checklist
- How to Tune Maximum Degree of Parallelism (MAXDOP)
- SQL Server 2012 Encryption Key Hierarchy
- How to Find a Blocking Process
- Top Wait Types and Descriptions
- SQL Server Fixed Server-Level Roles
- How to Find Which Files Belong to Which SQL Database
- How to Find and Alert on Deadlock Conditions
- How to Drop and Recreate Foreign Key Constraints
- How to Temporarily Disable Check Constraints and Database Triggers
- How to Find SQL Agent Tasks and Schedules
- How to Find Longest Running Queries
- How to Find the Up-Time of a SQL Server Instance
- Category: Uncategorized