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

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

What is Normal?

Phil Factor on the virtues of "over normalizing"  
By Phil Factor 2016/11/21 | Source: | 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: | 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,675 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,535 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: | Category: output
Rating: |  Discuss |   Briefcase | 2,500 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,219 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: | 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: | 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: | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,224 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: | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 6,149 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,164 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,648 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,053 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,446 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads

Can I Use Statistics to Design Indexes?

"I’ve noticed that many indexes in my data warehouse aren’t used frequently. Is there a way to use the automatically generated statistics to make useful indexes?" Kendra Little answers the question in episode 18 of Dear SQL DBA.  Read more...
By Additional Articles 2016/11/15 | Category: statistics
Rating:  Rate this |   Briefcase | 3,657 reads

Local Database Issues

Steve Jones talks about the issues with using a local database in your application.  Read more...
By Steve Jones 2016/11/14 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

THE Database Engine

Today Steve Jones comments on the ultimate database engine.  Read more...
By Steve Jones 2016/11/14 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 109 reads

SQL Server 2016 Distributed Availability Groups

High availability solution with cross cluster support using the new Distributed Availability Groups  Read more...
By Jennifer Brocato 2016/11/14 | Source: | Category: always on
Rating: |  Discuss |   Briefcase | 766 reads

Top 6 MySQL DBA Mistakes

To err is human, or so the saying goes. Unfortunately, in the world of IT, innocuous mistakes made early on can lead to really daunting problems down the road. In this article, Rob Gravelle goes over a few of the most common DBA mistakes to avoid. Some of these relate specifically to MySQL, while others may be applicable to any RDBMS.  Read more...
By Additional Articles 2016/11/14 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 3,617 reads
<< Newer    Items 41 to 60 of 15264    Older >>