Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 81 to 100 of 13862    Older >>
 

What Not To Say

Steve Jones has some advice for data professionals today. These are a few things that your boss doesn't want to hear, and you probably don't want to say.  Read more...
By Steve Jones 2015/06/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 662 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 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,153 reads

Query Folding in Power Query to Improve Performance

In this tip Koen Verbeeck discusses query folding, how you can take advantage from it and how to make sure query folding takes place.  Read more...
By Additional Articles 2015/06/03 | Source: MSSQLTips.com | Category: power query
Rating: (not yet rated)  Rate this |   Briefcase | 2,360 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice

One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.  Read more...
By Mickey Stuewe 2015/06/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,131 reads

Finding Production Drift

The changes made to production can be problematic at times. Steve Jones notes we can't prevent them, but we can look for them.  Read more...
By Steve Jones 2015/06/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

Cybercrime - the Dark Edges of the Internet

Criminal activity is a growing menace on the internet: This inevitably means more diligence is required by legitimate users in the face of an increasingly sophisticated criminal threat. Robert Sheldon describes some of the emerging threats and risks.  Read more...
By Additional Articles 2015/06/02 | Source: SimpleTalk | Category: cybercrime
Rating: (not yet rated)  Rate this |   Briefcase | 3,668 reads

Take our SQLServerCentral Users Survey

Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.  Read more...
By Press Release 2015/06/02 (first published: 2015/05/26) | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 11,916 reads

A Case FOR Cursors...

We've all heard that definitive statement: "Avoid using cursors." But, in my opinion, what really should be conveyed is: "Avoid using row-by-row operations when possible."  Read more...
By Chris Jones 2015/06/01 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 8,921 reads

Your Job

Steve Jones has a few comments on what your job is as a technologist.   Read more...
By Steve Jones 2015/06/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 185 reads

Who Cares About Your Data?

The observation that people hear what they want to hear is not a new one, and yet the extent to which people will go out of their way to ignore or misinterpret evidence can still surprise.  Read more...
By Dave Convery 2015/06/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 74 reads

Converting Comma Separated Value to Rows and Vice Versa in SQL Server

Often while reporting you will encounter a situation where you will have comma separated values in a single column but you want to report them in rows. In other cases you might have values in multiple rows and want them to be a single value separated by comma or some other character. Arshad Ali demonstrates how to write queries in SQL Server to handle these scenarios quickly.  Read more...
By Additional Articles 2015/06/01 | Source: Database Journal | Category: convert row to column
Rating: (not yet rated)  Rate this |   Briefcase | 5,503 reads

The MidnightDBAs release Minion Backup

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup. We created Minion Backup (or MB, for short) to be the most flexible, feature-rich backup solution possible.  Read more...
By Press Release 2015/06/01 | Source: SQLServerCentral.com | Category: minionware
Rating: |  Discuss |   Briefcase | 1,279 reads

Big Data for SQL folks: The Technologies (Part II)

SQL Server Big Data. Is the end Near for ETL as we know is? Will RDBMs be obsolete? What is NoSQL? What is Hadoop? Big Data-the whole story.  Read more...
By Frank A. Banin 2015/05/29 (first published: 2013/11/21) | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 12,204 reads

Statistical Analysis

This week Steve Jones asks the questions about advanced data analysis and statistics you might be using in your applications.  Read more...
By Steve Jones 2015/05/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 140 reads

A Plethora of PowerShell Pitfalls: Part 2

There are some pitfalls in PowerShell for the unwary. Many people who are learning PowerShell come across quirks that can cause frustration. Michael Sorens continues his series, warning abut four of the most common PowerShell pitfalls and explains how to avoid them.  Read more...
By Additional Articles 2015/05/29 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 6,342 reads

Retrieving a Binary File from Your Database

In this second article I provide the means to restore a binary file to its original state.   Read more...
By Eric Notheisen 2015/05/28 | Source: SQLServerCentral.com | Category: clr
Rating: |  Discuss |   Briefcase | 4,220 reads

The Hidden Patterns in Data

Looking at statistics and data to draw conclusions can be hard. Steve Jones comments on an interesting way of analyzing data from TED.  Read more...
By Steve Jones 2015/05/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 158 reads

Take our SQLServerCentral Users Survey

Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.  Read more...
By Press Release 2015/06/02 (first published: 2015/05/26) | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 11,916 reads

Converting and Using Text Dates as SQL Server Dates

This tip describes some T-SQL techniques for converting a mmddyyyy string to a SQL Server date, handling rows with missing date strings, and comparing converted date strings.  Read more...
By Additional Articles 2015/05/28 | Source: MSSQLTips.com | Category: dates and conversion
Rating: (not yet rated)  Rate this |   Briefcase | 6,620 reads

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.   Read more...
By Gregory Larsen 2015/05/27 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,571 reads
<< Newer    Items 81 to 100 of 13862    Older >>