(Manoj Pandey) Microsoft has made few changes to its Certification path for the new version of SQL Server i.e. SQL Server 2016.
Tag: sql server
Upgrading to SQL Server 2016: Pre-upgrade tasks
(Thomas LaRock) In our previous post on upgrading to SQL Server 2016, we talked about the reasons you might have for wanting to upgrade. For this post, we will look at the pre-upgrade checklist items you should consider before upgrading to SQL Server 2016.
SSIS Error: DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005
(Bob Pearson) DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005
How to Secure Your Azure Storage Infrastructure
(Christos Matskas) Azure storage is an essential foundation for the more sophisticated services that Microsoft Azure provides. It is therefore important to understand how to make access to your data in Azure storage secure, to control access appropriately, to log activity and to get metrics on usage
Read SQL Server Error Logs with Powershell and SMO
(Jack Vamvas) SQL Server troubleshooting and SQL Server problem analysis usually results in a DBA reading the SQL Server Error Logs and other error logs , such as Windows Events Logs.
Why is a Windows authenticated login more secure than a SQL authenticated one?
(Kenneth Fisher) I had this question come up at work the other day and while I knew it was true I wasn’t as sure about why as I’d like. The person I was working with wanted a real answer, not just Because I say so, so off to the internet I went.
Setting Variables in Calling T-SQL Code While Using sp_executesql
(Greg Larsen) In this short tip, I will show you how to set variables in your calling T-SQL code when using sp_execute sql.
Is there anything different in Azure with Elastic Pools when it comes to management?
(Denny Cherry) Short answer, “no”.
Drawing (again) with SQL Server
(Michael J. Swart) You have my permission to skip this post. This one’s just for me. So I’ve been drawing again with SQL Server’s spatial results tab, the first time I posted something was with Botticelli’s Birth of Venus in More images from the Spatial Results Tab.
SQL SERVER – FIX: The SQL Server Failed to Initialize VIA Support Library [QLVipl.dll]
(Pinal Dave) My every interaction with client teaches me something new. Recently someone contacted me through email and informed that they have issues with SQL Server Startup. When we checked ERRORLOG, we found below messages at the end of the ERRORLOG where Via Support library was mentioned.
