Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2014/01/07 to 2014/01/14

New SQL Monitor Custom Metric: Default User Service Account

Using a default account for SQL Server services can be a security risk for two reasons. Firstly, it can give the service a higher level of permissions than it needs. Secondly, isolation is compromised by several services running under the same account. This metric checks whether SQL Server services are running under any of the default accounts, such as localsystem.  Read more...
By Press Release 2014/01/14 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 1,745 reads

Generate two-dimensional QR Code® bar codes in an SSRS report

QR (Quick Response) Code® is the Denso Wave, Inc. trademark for a type of two-dimensional bar code designed for the automotive industry in Japan. The QR Code system has become popular outside the automotive industry due to its speed and greater storage capacity compared to standard UPC bar codes.  Read more...
By Stan Kulp 2014/01/14 | Source: SQLServerCentral.com | Category: qr code
Rating: |  Discuss |   Briefcase | 6,428 reads

SQL Enlight for SQL Server Management Studio

The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that was difficult to automate for release and deployment. As it is now both a Command-line utility and an SSMS add-in, the database developer can see immediately the parts of the code that would raise eyebrows with the vigilant production DBA.  Read more...
By Additional Articles 2014/01/14 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,571 reads

Cleveland, OH - SQL in the City Seminar - Deployment Stairway

Grant Fritchey and Steve Jones will be hosting a free seminar in Cleveland on February 7 2014. Join fellow database professionals to learn tips and best practices for SQL Server version control, continuous integration and deployment.   Read more...
By Press Release 2014/01/13 | Source: SQL in the City | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,251 reads

Agile Database Development

Agile methodologies work well with database developments only if great care is taken to do things right. It requires good judgement and leaves little room for error. Dev Nambi, in an extract from the book Tribal SQL, argues that Agile works for smart, curious, and experienced software engineers.  Read more...
By Additional Articles 2014/01/13 | Source: SimpleTalk | Category: agile database techniques
Rating:  Rate this |   Briefcase | 4,466 reads

Understanding Peer-to-Peer Transactional Replication, Part 1

There are times when you need to share tables between servers, where the table may be updated in both places. Peer-to-Peer Transactional Replication gives you the ability to create a solution. I explain the benefits and the downfalls.  Read more...
By John F. Tamburo 2014/01/13 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 3,305 reads

Stop & Start Your VM’s on Azure with Powershell

This is a very simple script can be used as a framework for you to stop and start your VM’s on Azure with Powershell.  Read more...
By Additional Articles 2014/01/10 | Source: TechNet Blogs | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,105 reads

Fuzzy-String Search: Find misspelled information with T-SQL

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,516 reads

Stairway to SQLCLR Level 1: What is SQLCLR?

The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.  Read more...
By Solomon Rutzky 2014/01/09 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 9,746 reads

An Introduction to Windows Azure Table Storage

Windows Azure Tables are intended for the storage of large amounts of schemaless data. Tables are just containers of rows of data. Mike Wood describes the practicalities of getting started with using the system.  Read more...
By Additional Articles 2014/01/09 | Source: SimpleTalk | Category: azure
Rating:  Rate this |   Briefcase | 1,826 reads

Relational database or graph database? Why not have both?

SQL Server may not be the best solution for every problem, but we have the means to extend its capabilities by linking it to external resources; in this case, using SQLCLR to query a graph database.  Read more...
By Tony Bater 2014/01/08 | Source: SQLServerCentral.com | Category: nosql
Rating: |  Discuss |   Briefcase | 6,965 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2014/10/08 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 42,516 reads

SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines

This article describes how to use the new wizards in SQL Server Management studio to get access to Windows Azure and then create and configure your VM.   Read more...
By Additional Articles 2014/01/08 | Source: TechNet Blogs | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 1,764 reads

Who won the Tribal Awards?

Read on to see the 11 winners of the Tribal Awards as chosen by the technical community.   Read more...
By 2014/01/07 | Source: SQLServerCentral.com | Category: awards
Rating: |  Discuss |   Briefcase | 1,137 reads

An AlwaysOn Bug with Service Broker Transmission Queue

Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.  Read more...
By Paul Brewer 2014/01/07 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 2,623 reads

Data Science Laboratory System – Graph Databases

Graph database are an intriguing alternative to the relational model. They apply graph theory to record the relationships between entries more naturally, and are a good fit for a range of data tasks that are difficult in SQL. Buck Woody gives an introduction to Graph databases and shows how to get Neo4J up and running to get familiar with the technology.   Read more...
By Additional Articles 2014/01/07 | Source: SimpleTalk | Category: data science
Rating:  Rate this |   Briefcase | 2,738 reads