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

<< Newer    Items 61 to 80 of 15278    Older >>
 

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 | 124 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,232 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,328 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,184 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,656 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,061 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,475 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 | 72 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,696 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 65 reads

THE Database Engine

Today Steve Jones comments on the ultimate database engine.  Read more...
By Steve Jones 2016/11/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 115 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: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 780 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,632 reads

Performance Improvement for Cursors in Stored Procedures

Exploring some differences between using cursors, local fast forward cursors and using set logic.  Read more...
By Brian Hibbert 2016/11/11 (first published: 2015/02/03) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 11,048 reads

The Google Solution

Google had an interesting solution to managing their databases.   Read more...
By Steve Jones 2016/11/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

Multi-Step Input Forms in ASP.NET MVC

It is a common problem with a web page that a form is too complex to fit easily on the page. You can, of course, rely on the scrollbar, but it soon becomes a daunting and erratic process for the poor user. Wizards, that allow you to guide the user through a process, are great but take time to set up. Is there a simple solution for those occasions where there is too much data-entry for a form but a full wizard seems like overkill?  Read more...
By Additional Articles 2016/11/11 | Source: SimpleTalk | Category: asp.net
Rating: (not yet rated)  Rate this |   Briefcase | 2,817 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,328 reads

Go Code

Steve Jones wants more people to learn to code.  Read more...
By Steve Jones 2016/11/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Data Lifecycle Management using SQL Server

With the data proliferation issues, a well-defined lifecycle for data retention is a growing demand.  Read more...
By Joao Osorio 2016/11/10 | Source: SQLServerCentral.com | Category: ilm
Rating: |  Discuss |   Briefcase | 1,039 reads
<< Newer    Items 61 to 80 of 15278    Older >>