Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 41 to 60 of 15269    Older >>
 

Monitor All the Changes

Today Steve Jones looks at the potential downfalls of monitoring every change without lots of filtering.  Read more...
By Steve Jones 2016/11/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

SSC 2016 User Survey and Competition

What do you want to see more of on SQL Server Central? Anything you think we should get rid of? Let us know in this 17-question user survey, and at the end you can choose to be entered into a draw to win a $100 Amazon gift card. Thanks to everyone who's already answered, we greatly appreciate the feedback!  Read more...
By 2016/11/22 (first published: 2016/11/07) | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 6,273 reads

Service Broker Error Handling

How to handle errors raised during Service Broker Queue Processing.  Read more...
By Paul Milligan 2016/11/21 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 720 reads

Implementing a custom sort

Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.  Read more...
By Additional Articles 2016/11/21 | Source: SQLPerformance.com | Category: order by
Rating:  Rate this |   Briefcase | 2,999 reads

Wow. Just Wow

Today Steve Jones looks at the loss of a database backup on a public website.  Read more...
By Steve Jones 2016/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 137 reads

What is Normal?

Phil Factor on the virtues of "over normalizing"   Read more...
By Phil Factor 2016/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 84 reads

Share the Interesting Work

Today we have a guest editorial from Andy Warren that looks at how we might divvy up our workload in a company.  Read more...
By Andy Warren 2016/11/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2016/11/18 (first published: 2015/09/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,691 reads

How to Start Big Data with Apache Spark

It is worth getting familiar with Apache Spark because it a fast and general engine for large-scale data processing and you can use you existing SQL skills to get going with analysis of the type and volume of semi-structured data that would be awkward for a relational database. With an IDE such as Databricks you can very quickly get hands-on experience with an interesting technology.  Read more...
By Additional Articles 2016/11/18 | Source: SimpleTalk | Category: big data
Rating:  Rate this |   Briefcase | 2,543 reads

Getting more done with OUTPUT

Use OUTPUT to perform an INSERT and a DELETE at the same time.  Read more...
By Kenneth Fisher 2016/11/17 | Source: SQLServerCentral.com | Category: output
Rating: |  Discuss |   Briefcase | 2,512 reads

How to resolve SSIS access denied error in SQL Server Management Studio

Receiving an access denied error message when trying to connect to a remote instance of SSIS from SSMS? Sadequl Hussain provides the solution.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,223 reads

A Joke Come True

SQL Server is finally coming to Linux, a joke from Steve for years.  Read more...
By Steve Jones 2016/11/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 123 reads

Held Hostage by the Database

Does your database development process prevent changes in your software? You shouldn't be held hostage by your database.  Read more...
By Steve Jones 2016/11/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 78 reads

Stairway to U-SQL Level 11: Stored Procedures

To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.  Read more...
By Mike McQuillan 2016/11/16 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,226 reads

SSC 2016 User Survey and Competition

What do you want to see more of on SQL Server Central? Anything you think we should get rid of? Let us know in this 17-question user survey, and at the end you can choose to be entered into a draw to win a $100 Amazon gift card. Thanks to everyone who's already answered, we greatly appreciate the feedback!  Read more...
By 2016/11/22 (first published: 2016/11/07) | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 6,273 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 2016/11/16 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 88,169 reads

More Power BI to your Elbow

Power BI Desktop continues to evolve. There have been many improvements to the reporting side that together make it easier to get from the data to the visualisation as quickly as possible. You can now create line charts that let users drill down into hierarchical data. There are now ways of adding dynamic reference lines to a visualization that provide users with relevant reference points. Robert Sheldon demonstrates how to combine these features to great effect.  Read more...
By Additional Articles 2016/11/16 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,654 reads

Exporting Data from JSON to CSV with SSIS

The following tutorial will show how to export JSON data to a CSV file using SSIS  Read more...
Rating: |  Discuss |   Briefcase | 1,056 reads

Free Webinar - Redgate DLM Demo

Learn how to use Redgate’s DLM solution to improve your database change management process in our free webinar on November 15th. Microsoft Data Platform MVPs, Steve Jones, and Grant Fritchey, will demonstrate how Redgate’s tools plug into Subversion, TeamCity & Octopus Deploy so that you can build, test and deploy your database alongside your application code. Register now.  Read more...
By 2016/11/15 (first published: 2016/11/10) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 6,468 reads

A New Recovery Tool for Your Toolbelt

Learning a new skill is always helpful, especially for backup and restore. Steve Jones talks about an idea from the SQLCAT team.  Read more...
By Steve Jones 2016/11/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads
<< Newer    Items 41 to 60 of 15269    Older >>