Subscribe: SQLServerCentral.com Articles
http://www.sqlservercentral.com/sscrss.xml
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
article  code  data  database  disk bottlenecks  disk  dynamic sql  dynamic  new  server  sql server  sql  step  transaction log 
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



 



Analysing Sales Patterns: R + SQL Server

Fri, 18 Aug 2017 06:00:00 UT

We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.




Database Code Analysis

Fri, 18 Aug 2017 06:00:00 UT

Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.




Testing COALESCE with tSQLt

Thu, 17 Aug 2017 06:00:00 UT

Learn how you can use tSQLt to test your COALESCE queries.

(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.



How to Read a Transaction Log Backup

Thu, 17 Aug 2017 06:00:00 UT

The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups. This function is undocumented, so you should use care when using this function in a production environment.




Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD

Wed, 16 Aug 2017 06:00:00 UT

The first article in this Stairway Series makes the case for test-driven development.




Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Wed, 16 Aug 2017 06:00:00 UT

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.




Monitoring Azure Cloud and Hybrid Environments

Wed, 16 Aug 2017 06:00:00 UT

Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data and services are actually hosted. There is much to be said for an integrated approach to providing a unified view of entire application workloads on-premise. hybrid and cloud using the same tools wherever possible.




New permissions features brings access control to SQL Clone

Wed, 16 Aug 2017 06:00:00 UT

SQL Clone permissions has been high on the wish-list for users and the new feature addresses it in an intuitive way that enables you to allocate and change permissions quickly and easily.




Using Database Master Keys in SQL Server

Tue, 15 Aug 2017 06:00:00 UT

Learn the basics of Database Master Keys and how you can use them in SQL Server.




Let’s Corrupt a Database Together, Part 3: Detecting Corruption

Tue, 15 Aug 2017 06:00:00 UT

Having already shown how to corrupt a database, and then how nonclustered indexes can be corrupted independently, in this post Brent Ozar explains how you can detect corruption.




SQL Server Management Studio Tips

Mon, 14 Aug 2017 06:00:00 UT

Complete guide about hidden gems of SSMS




SQL Server function to check dynamic SQL syntax

Mon, 14 Aug 2017 06:00:00 UT

Although most of what you read tells you to stay away from dynamic SQL, the reality is there are places where writing T-SQL code dynamically just makes sense. The one downside to dynamic SQL is that if it is not written correctly the code will fail. Eli Leiba shares a function that he created to help determine if the dynamic code is OK prior to execution.

(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.



Using multiple custom SQL formatting styles in SQL Prompt

Mon, 14 Aug 2017 06:00:00 UT

Usually, when coding SQL, you will want to go along with the coding style of the team you are working with. This article shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to switch between them and apply a new style to existing code, with ease.




The ABCs of Database Creation

Fri, 11 Aug 2017 06:00:00 UT

Creating SQL Server databases is easier than the internet may lead us to believe.




Introduction to Azure SQL Data Sync

Fri, 11 Aug 2017 06:00:00 UT

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In thius article, Martin Policht will introduce its main characteristics.




Filegroup Restoring and Join Elimination

Thu, 10 Aug 2017 06:00:00 UT

This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.




SQL Server R Services: The Basics

Thu, 10 Aug 2017 06:00:00 UT

It is possible to do a great deal with R within SQL Server, but it is best to start by doing analysis in R on numeric data from SQL Server and returning the results to SQL Server. There is great value to be gained even with this basic foundation. Robert Sheldon is on hand to give you a kick start with the first in his series on beginning with R in SQL Server.




Stairway to AlwaysOn Level 2: Storage 101

Wed, 09 Aug 2017 06:00:00 UT

In this new level of the stairway, we examine the storage knowledge you need for an AlwaysOn configuration.




Free eBook: Understanding SQL Server Concurrency

Wed, 09 Aug 2017 06:00:00 UT

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.




Microsoft IT: A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1

Wed, 09 Aug 2017 06:00:00 UT

This paper shares the approach used to understand and determine: 1) Using ‘Hekaton’ in SQL Server 2014 against RPM, including performance analysis. 2) Understand the specifics involved while migrating to Hekaton.




Sliding Scale Parallelism: Why Stop At DOP?

Wed, 09 Aug 2017 06:00:00 UT

Erik Darling wonders why SQL Server doesn't have more granular parallelism options.




Fixing Plan Issues in the Middle of the Night

Tue, 08 Aug 2017 06:00:00 UT

Do you hate when someone wakes you up in the middle of the night and tells you that some query is slower and you need to investigate it? With SQL Server 2017 you might easily do this, or even let SQL Server do this job for you.




How to Automatically Create and Refresh Development and Test Databases

Tue, 08 Aug 2017 06:00:00 UT

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database is big. Phil illustrates a solution by taking a set of Redgate tools to show how they can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers with the database build, taking care to save any DDL changes to the existing copies of the database.




Removing sensitive data from a database

Tue, 08 Aug 2017 06:00:00 UT

It’s fairly widely known that just because you delete data from a database, it doesn’t mean it’s gone from the data file itself, but the question is, how should you go about removing it?




Using Super Keys to Enforce Database Constraints

Mon, 07 Aug 2017 06:00:00 UT

Example of Using Super Keys to Enforce Database Constraints, instead of procedural code




SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips

Mon, 07 Aug 2017 06:00:00 UT

Serget Gigoyan is back with another set of 5 common SSMS tips.




Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL

Fri, 04 Aug 2017 06:00:00 UT

This example demonstrates how to perform a pivot using dynamic headers based on the row values of a table. The article also shows how to pass a temp table variable to a Dynamic SQL call.

(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.



Developing Metadata Design Patterns in BIML

Fri, 04 Aug 2017 06:00:00 UT

You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a small change, such as an alteration to the network topology, means that they all need to be altered with the correct connection details. Perhaps you should consider creating design patterns for all the standard components of integration tasks in BIML, and generating the SSIS packages from these? Amarendra walks you through the process.




Fuzzy Search

Thu, 03 Aug 2017 06:00:00 UT

Finally a fuzzy search that finds all sorts of misspellings and missing parts.




Ingest data from a web page into SQL Server 2017 using R

Thu, 03 Aug 2017 06:00:00 UT

Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server.