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

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

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,034 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 | 128 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,811 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,196 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,028 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,456 reads

Azure SQL Database - Implementing Azure AD Authentication

Marcin Policht focuses on the specifics of using Azure Active Directory to authenticate to Azure SQL Database.  Read more...
By Additional Articles 2016/11/10 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 5,206 reads

Stairway to Biml Level 6 - Programming with Metadata

In this next level of the Stairway to Biml, learn how metadata makes your Biml code more efficient and helpful in generating packages.  Read more...
By Reeves Smith 2016/11/09 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 819 reads

Byte Me: Plugged in

By Bob Lang 2016/11/09 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 37 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2016/11/09 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 61,375 reads

Find and Remove Duplicate Rows from a SQL Server Table

Though duplicate rows are bad practice, sometimes they're necessary for a short time. But how do you clean your tables when they're no longer needed? Sergey Gigoyan provides a few different solutions.  Read more...
By Additional Articles 2016/11/09 | Source: MSSQLTips.com | Category: rows
Rating: (not yet rated)  Rate this |   Briefcase | 2,862 reads

Bring Solutions

In today's world, technology workers need to point out solutions, not problems.  Read more...
By Steve Jones 2016/11/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 185 reads

Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.  Read more...
By Mike McQuillan 2016/11/08 | Source: SQLServerCentral.com | Category: over
Rating: |  Discuss |   Briefcase | 3,283 reads

SQL Server Timeouts During Backups and CHECKDB

So you’re hosting your SQL Server in the cloud, and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems - what's going on? Brent Ozar explains.  Read more...
By Additional Articles 2016/11/08 | Source: Brent Ozar Unlimited Blog | Category: checkdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,973 reads

How Do You Act When You Need to Learn New Technology?

Today we have a guest editorial from Ben Kubicek as Steve is away from the office. It is hard to be humble, but it is needs to learn something new.  Read more...
By Ben Kubicek 2016/11/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 142 reads

TempDB growth due to version store on AlwaysOn secondary server

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.  Read more...
By Ramya Makam 2016/11/07 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,020 reads

I can ODBC clearly now

ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?  Read more...
By Phil Factor 2016/11/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 68 reads

Power BI for Data Modelling

Power BI has a lot of uses, but one of the most interesting of them is to model and shape data to make it easier for self-service BI. Power BI is a full-stack solution that includes data loading, data modelling, metrics, reporting and distribution. It can take the source data, and perform in-process data modelling relatively easily as well a providing an easy to use and powerful user interface for analytics and reporting.  Read more...
By Additional Articles 2016/11/07 | Source: SimpleTalk | Category: bi
Rating: (not yet rated)  Rate this |   Briefcase | 3,522 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,196 reads
<< Newer    Items 61 to 80 of 15264    Older >>