Explore Sql Server and more!

Using PowerShell for SQL Server Analysis Services tasks - Part 1

Using PowerShell for SQL Server Analysis Services tasks - Part 1

SQL Server Clustering Myths

Recently a group of developers were looking for high availability solutions with SQL Server and ran into some problems because they believed some common myths regarding SQL Server and clustering. In this tip we'll look at some of these myths and correct t

Recover access to a SQL Server instance

Starting with SQL Server the local Administrators group is no longer added by default during SQL Server setup; you even have to use a manual step to add the current user as a local administrator.

SQL Server Reporting Services Report and Group Variable References

SQL Server Reporting Services Report and Group Variable References

Backup and Restore SQL Server databases with Azure cloud services and SMO.

Backup and Restore SQL Server databases with Azure cloud services and SMO.

Data tapping during SSIS package execution in SQL Server 2012

Data tapping during SSIS package execution in SQL Server 2012

Tip of the Day - Storing passwords in SQL Server – things to know to keep the data secure

Convert the hexadecimal string to a clear text string Storing passwords in SQL Server

Renaming the SharePoint Admin Content Database to Follow SQL Server Naming Conventions

I've been tasked to manage the SharePoint 2010 database server after deployment. While looking at the list of databases, I saw several databases that have GUID values appended to their names, one of them is the SharePoint Admin Content database.

How to Enable Secondary Decryption of SQL Server Symmetric Keys

In this tip we look at how to setup secondary encryption and decryption keys that can allow a user to access data that was encrypted by multiple methods.

Tool to Deploy SQL Server Database Changes

Tool to Deploy SQL Server Database Changes

Pinterest
Search