I read Aaron Bertrand’s tip about dropping and re-creating all foreign key constraints using T-SQL with the FOR XML clause. He invited others to provide other options, so here is my script using PowerShell.
Some of our developers noticed an issue a few days after celebrating our successful SQL Server 2012 upgrade. When they run a query in SSMS and copy and paste the results to Excel, each row gets split into many rows in Excel instead of one row like it used to do. They immediately started blaming SQL Server 2012, because no other changes were made, why is this happening?
As a DBA I am always looking for ways to improve performance. Bulk loading data while it seems like a pretty straightforward task does have some different options that can be implemented to both improve the speed at which data is loaded as well as decrease the total amount of resources used to perform the data load. This tip will look at a few of those options.
I have a chart in SQL Server Reporting Services (SSRS), based upon data from a SQL Server table. I want to add a linear trendline to this chart, just like in Excel. In this tip we cover how this can be done.
My organization is beginning to invest in Infrastructure as a Service (IaaS), one of the things we are interested in doing is migrating backups to the cloud. In this tip we cover the steps to backup databases to the cloud.
You are an experienced SQL Server DBA and you wish to use PHP to provide some front end web pages to help with monitoring and management. How do you setup PHP and SQL Server? What are the steps? What needs to be installed? Can you provide any checklists?
PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. In this tip we cover creating a patching policy for SQL Server.
I installed SQL Server 2014, but now the SSDT application used to develop BI solutions in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS) is missing. �In this tip we cover how to install the tools.
In data mining, we often need to perform min-max normalization on numeric data type columns to prevent one column from skewing or dominating the models produced by the machine learning algorithms.
Being able to identify SQL Server performance issues at the drop of a hat is easier said than done. Without a means to collect and analyze the performance data it is difficult at best to understand and correct the items in a timely manner. SQL Server ships with a handful of tools to include Profiler, SysmonPerfmon and the Database Engine Tuning AdvisorIndex Tuning Wizard. Much of the time these tools meet the needs for manual collection and analysis, but what if you need to go beyond the tools that are available and to resolve a performance issue quickly?