Subscribe: SQLServerCentral.com Articles
http://www.sqlservercentral.com/sscrss.xml
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
article  bottlenecks  data  database  disk bottlenecks  disk  fix  server  simple talk  sql server  sql  step  talk editor 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: SQLServerCentral.com Articles

SQLServerCentral.com Articles



Articles posted on SQLServerCentral.com



 



SSRS Audit: All reports executed/not-executed during previous 30 days

Tue, 25 Apr 2017 06:00:00 UT

This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them.




SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

Tue, 25 Apr 2017 06:00:00 UT

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Selecting and Configuring Hardware for SQL Server 2016 Standard Edition

Tue, 25 Apr 2017 06:00:00 UT

Glenn Berry explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Should I Type * or 1 With the EXISTS Logical Operator

Mon, 24 Apr 2017 06:00:00 UT

In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.




Building Dynamic React Apps with SQL Server Data

Mon, 24 Apr 2017 06:00:00 UT

This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.




6 shades of masking your data

Mon, 24 Apr 2017 06:00:00 UT

The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, Toby Smyth runs through all six.




Stairway to Columnstore Indexes Level 2: Columnstore Storage

Fri, 21 Apr 2017 06:00:00 UT

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Extending DevOps practices to SQL Server databases

Fri, 21 Apr 2017 06:00:00 UT

In this free demo webinar, Grant Fritchey and Arneh Eskandari will show how Redgate tools enable you to push and pull database changes in Git, then set up an automated database build and deployment process using TeamCity and Octopus Deploy.




Performance Tuning Using Extended Events: Part 1

Thu, 20 Apr 2017 06:00:00 UT

In this article, learn how to identify performance tuning opportunities using Extended Events.




The right way to approach a legacy code base

Thu, 20 Apr 2017 06:00:00 UT

Andrea Angella shares what he learned from attending Michael Feather's workshop on working effectively with legacy code.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Package Parts – First Impressions

Wed, 19 Apr 2017 06:00:00 UT

This article gives an overview of some good and not-so-good features of SSIS package parts.




Free eBook: Inside the SQL Server Query Optimizer

Wed, 19 Apr 2017 06:00:00 UT

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.




Working with the BigInt Type in Node and SQL Server

Wed, 19 Apr 2017 06:00:00 UT

Node.JS and SQL Server are a good match for creating non-blocking, event-driven database applications. Though you can use ODBC or JDBC to communicate between the two, it is possible to run such applications on platforms such as Azure, Linux, OSX and iOS by using Node together with the JavaScript TDS library called 'Tedious'. 'Tedious' is a mature product but it is still possible to get things wrong in converting SQL Server datatypes such as BigInt to native Javascript data.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Working with Tables in Azure SQL Data Warehouse

Tue, 18 Apr 2017 06:00:00 UT

In this next installment of our series on Azure SQL Data Warehouse, we'll look at tables and the options for how we decide to create them for optimum performance.




Moving from application automation to true DevOps by including the database

Tue, 18 Apr 2017 06:00:00 UT

Tom Austin talks about the challenges that arise from trying to include the database in your DevOps process.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Scaling out SSRS on SQL Server Standard Edition 

Tue, 18 Apr 2017 06:00:00 UT

The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS on SQL Server Standard Edition, it required some creative thinking. This article describes his solution, its merits and drawbacks.




The Connection to the Primary Replica is not Active

Mon, 17 Apr 2017 06:00:00 UT

In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Performance Myths : Clustered vs. Non-Clustered Indexes

Mon, 17 Apr 2017 06:00:00 UT

Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.




Creating Azure SQL Data Warehouse Databases

Fri, 14 Apr 2017 06:00:00 UT

Learn how you can create an Azure SQL Warehouse database quickly and easily.




Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services

Fri, 14 Apr 2017 06:00:00 UT

One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. In this article, Marcin Policht looks at using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, he will rely on Visual Studio Team Services.




Nuance of datetime data type in SQL Server

Thu, 13 Apr 2017 06:00:00 UT

One of the most confusing data types in SQL Server is the datetime datatype.




Harmful, Pervasive SQL Server Performance Myths

Thu, 13 Apr 2017 06:00:00 UT

Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.