(Manoj Pandey) On 2nd October 2017 Microsoft released the full & final General Available (GA) version of SQL Server 2017.
Tag: sql server
Postponing Our Use of In Memory OLTP
(Michael J. Swart) Sometimes I get asked about work and our software development practices. Often these questions use words like agile, devops, or continuous delivery as in “Are you agile?” or “Do you do continuous delivery?”. But these questions rarely have yes or no answers. I always want to answe
SQL SERVER – How to Find Stored Procedure Execution Count and Average Elapsed Time?
(Pinal Dave) Every single time when I go for Comprehensive Database Performance Health Check, I get many different questions from the users. However, there are some questions which are very common and I have started to build a list of the such questions so I can share the same with you. Today’s ques
Object Dependencies
(PCREDDY) To find Objects’ dependencies, use the code below.
Setup and Implement SQL Server 2016 Always On Basic Availability Groups
(Edwin Sarmiento) In a previous tip on Configure SQL Server Database Mirroring Using SSMS, we have seen how we can configure Database Mirroring to achieve local high availability for SQL Server databases. We need to upgrade our SQL Server 2008 R2 databases before extended support ends.
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with Error 0x2, Status Code 0x38
(Pinal Dave) I just love my On Demand offering because it gives me more pleasure of assisting clients who are in urgent need of an SQL expert. Most of the time I am called for help when clients are not able to start SQL Service due to some reason. Today we will see how to fix an error which is […]
New Features and Best Practices of SQL Server PowerShell
(Aaron Nelson) In the past, to install the SQL PowerShell cmdlets module you either had to install SQL Server Management Studio (SSMS) or install the SQL Server database engine. This situation causes a large footprint in the cases where you just wanted to have the cmdlets available on a separate se
SQL SERVER – Connecting Specific Database on Starting SSMS
(Pinal Dave) In today’s blog post we are going to learn how to connect specific database directly when we start SQL Server Management Studio. Honestly, this is a very simple process, but I have seen quite a few DBA still unaware of this feature.
SQL Server Reporting Services Custom Security with Single Sign-on
(Kannan Kandasamy) How do you implement Single Sign-On authentication based on SAML 2.0 response on SQL Server Reporting Services 2016 and Power BI Report Server?
SQL SERVER – How to Delete a Single Table From SQL Server Backup File (.bak)
(Pinal Dave) Question: How to Delete a Single Table From SQL Server Backup File (.bak)?