(Robert Sheldon) SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially.
Tag: sql server
SQL SERVER – How Much Free Space I Have in My Database?
(Pinal Dave) This is one of the simplest query that I wrote for one of my consulting customers who asked me. When I was discussing with the customer on some of the best practices of working with SQL Server, I was telling him not to use the autogrowth as a regular feature to use. I wanted the DBA to
SQL Server 2016 Reporting Services Mobile Report
(Scott Murray) So you want to develop mobile reports for SQL Server Reporting Services (SSRS)? What options are available? Are there any new features in SQL Server 2016 that can streamline the process? How do I get started?
Comparing two query plans
(Kenneth Fisher) T-SQL Tuesday This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. The feature I want to talk about has been around for a bit. Not because it’s not part of SQL 2016 but because it’s part of SQL Server Management Studio.
Stored Procedures Do Not Protect from SQL Injection Attacks – See more at: http://www.devx.com/dbzone/stored-procedures-do-not-protect-from-sql-injection-attacks.html#sthash.EQk8yxry.dpuf
(Declan Hillier) I often hear people say that using stored procedures protects you against SQL injection attacks. This is incorrect.
Using some best practices for SQL Server in Azure VM (IaaS) to get MAX performance
(Manoj Pandey) I was setting up an environment on Azure Premium Storage (G-Series) server for my Project, and was not getting the performance I was expecting. The comparison was against an existing Database Server setup on an On-Premise VM.
SQL Server Service Broker – Networking
(Colleen M. Morrow) This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.
SQL Server 2016 SSMS
(Vinoth N Manoharan) With the official release of SQL Server 2016 this month let’s try out what is new in SSMS 2016 and how we can access the new 2016 features via SSMS.
Discontinued Database Engine Functionality in SQL Server 2016
(Dinesh Asanka) Major discontinued feature of the SQL Server 2016 feature is that exclusion of 32 bit of the SQL Server. So now on, you have only 64 bit version.
Using Power BI with Enterprise, On-premises Data
(Paul Turley) I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data. The running time for all four parts is about 44 minutes. I cover using the Power BI Enterprise Gateway to connect published Power BI reports to on-premises data sources: