SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,889,657 DBAs, developers and SQL Server users

Rss
Headlines today   August 21, 2017

Azure DWH part 14: PolyBase to access to Non relational data

In this article, we will learn how to work with PolyBase using Azure SQL DWH.   Read more...
By Daniel Calbimonte 2017/08/21 | Source: SQLServerCentral.com | Category: polybase
Rating: |  Discuss |   Briefcase | 236 reads

Is It Time To Stop Using IsNumeric()?

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.  Read more...
By Additional Articles 2017/08/21 | Source: SimpleTalk | Category: isnumeric()
Rating: (not yet rated)  Rate this |   Briefcase | 2,491 reads

Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins

Join Microsoft Data Platform MVP, Grant Fritchey, for our next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Git and Jenkins to show you how Redgate's Database DevOps solution helps you build, test and deploy your database changes alongside your app code.  Read more...
By 2017/08/21 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,054 reads
Previous headlines

Analysing Sales Patterns: R + SQL Server

We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.  Read more...
By Nick Burns 2017/08/18 (first published: 2015/12/15) | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 6,751 reads

Database Code Analysis

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.  Read more...
By Additional Articles 2017/08/18 | Source: SimpleTalk | Category: code analysis
Rating: (not yet rated)  Rate this |   Briefcase | 2,136 reads

Testing COALESCE with tSQLt

Learn how you can use tSQLt to test your COALESCE queries.  Read more...
By Steve Jones 2017/08/17 | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 1,214 reads

How to Read a Transaction Log Backup

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.  Read more...
By Additional Articles 2017/08/17 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 2,632 reads

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

The first article in this Stairway Series makes the case for test-driven development.  Read more...
By Sebastian Meine 2017/08/16 (first published: 2014/12/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,299 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

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.  Read more...
By Additional Articles 2017/08/16 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 82,308 reads

Monitoring Azure Cloud and Hybrid Environments

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.  Read more...
By Additional Articles 2017/08/16 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,337 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

Backup Log to Nul– #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2017/08/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 856 reads

Start Your Engine’s with Startup Procedures

After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...  Read more...
By SQLRUs 2017/08/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 963 reads
Question of the Day

SQLCMD compact Performance

By Steve Jones 2017/08/21 | Category: sqlcmd
Rating: (not yet rated) |  Discuss |   Briefcase | 426 reads

What parameter for SQLCMD will give performance statistics in a compact way, with the values just separated by a colon?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
73785 294224 SSC Guru  
2.
Jeff Moden
61703 273206 SSC Guru  
3.
Steve Jones - SSC Editor
38434 182696 SSC Guru  
4.
Lynn Pettis
27914 121259 SSC Guru  
5.
Lowell
26614 97022 SSC Guru  
Latest forum posts