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

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

Going Interactive with C#

For some time now, C# programmers have gazed enviously at the interactive capabilities of F#, Python and PowerShell. For rapid prototyping work and interactive debugging, dynamic languages are hard to beat. C# Interactive slipped into view quietly, without razzmatazz, in Visual Studio 2015 Update 1. It's good, it's worth knowing about; and Tom Fischer is intent on convincing you of that.  Read more...
By Additional Articles 2016/10/11 | Source: SimpleTalk | Category: .net
Rating:  Rate this |   Briefcase | 4,099 reads

Developer Deployment Frustrations

SQL Server should work to make it easy for developers to work with it, and include versions like Express in their applications.  Read more...
By Steve Jones 2016/10/11 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 334 reads

What do you do or think about on the way to work?

I recently changed jobs and my commute time doubled, I found myself with more time to think and I started asking questions.  Read more...
By Ben Kubicek 2016/10/10 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 97 reads

Bingle is my Senior DBA

When working with SQL Server, many people don't need the search engine to be their junior DBA, they need it to be their senior DBA.  Read more...
By Grant Fritchey 2016/10/10 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 108 reads

MDX Calculations Across Multiple Calendars Using Nested SCOPEs

A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs  Read more...
By Paul Burton 2016/10/10 | Source: | Category: mdx
Rating: |  Discuss |   Briefcase | 618 reads

Azure SQL Database - Azure AD Authentication

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, Marcin Policht provides an overview of this functionality.  Read more...
By Additional Articles 2016/10/10 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 3,479 reads

Introducing the Set-based Loop

Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.  Read more...
By Luis Cazares 2016/10/07 (first published: 2015/07/27) | Source: | Category: set-based loop
Rating: |  Discuss |   Briefcase | 17,284 reads

DBA Support

This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.  Read more...
By Steve Jones 2016/10/07 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 230 reads

How to generate T-SQL scripts in SQL Server Management Studio with the collation settings

SQL Server collation is an important setting when creating database objects. One of the best ways to ensure that collation issues do not happen is to ensure that the collation settings are properly specified in the script that generates the database objects - Siddharth Mehta demonstrates how to do this.  Read more...
By Additional Articles 2016/10/07 | Source: | Category: collation
Rating: (not yet rated)  Rate this |   Briefcase | 3,633 reads

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.  Read more...
By J. Drew Allen 2016/10/06 | Source: | Category: fifo queues
Rating: |  Discuss |   Briefcase | 1,952 reads

A Software Warranty

Steve Jones says that developers should take responsibility for the code they deploy, perhaps with a warranty of sorts inside their company.  Read more...
By Steve Jones 2016/10/06 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 136 reads

Taking Pictures from HTML

Sometimes a request from a user who doesn't appreciate the limitations of the technology can jolt you into discovering that an application feature that was, until recently, difficult to achieve is suddenly relatively easy. Dino was asked to allow the user to take photographs and associate them with an item of work. After he'd recovered from the shock, he decided that it was achievable, and now describes how he went on and did it.  Read more...
By Additional Articles 2016/10/06 | Source: SimpleTalk | Category: .net
Rating:  Rate this |   Briefcase | 4,100 reads

Redgate DLM Demo Webinar

Watch the recording of our latest DLM Demo webinar and learn how to improve your database change management process. See how Redgate DLM plugs into TFS, TFS Build & Octopus Deploy so that you can automate your database changes alongside your application code.  Read more...
By 2016/10/06 | Source: Redgate | Category: video
Rating:  Rate this |   Briefcase | 2,243 reads

Do you have DBA syndrome?

Sometimes DBAs become resistant to change. When they lose focus on their full purpose they may have DBA syndrome.  Read more...
By Ben Kubicek 2016/10/05 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 123 reads

Stairway to U-SQL Level 9: Views and C# Expressions

Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.  Read more...
By Mike McQuillan 2016/10/05 | Source: | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,020 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2016/10/05 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 79,517 reads

Pattern Matching : More Fun When I Was a Kid

Aaron Bertrand runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.  Read more...
By Additional Articles 2016/10/05 | Source: | Category: charindex
Rating: (not yet rated)  Rate this |   Briefcase | 2,970 reads

Audit Survey

Do you have a need to audit your database? Do you have compliance pressures? Redgate would like to build better tools in this area but need your help to understand the pain points. If you think you can help, please fill in their short survey.  Read more...
By 2016/10/05 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,710 reads

Questioning the Interviewer

Asking questions in an interview is important, but there can be issues. Steve Jones talks a little about how to approach this.  Read more...
By Steve Jones 2016/10/04 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 525 reads

PowerShell Solutions - Working with files

When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.  Read more...
By Daniel Calbimonte 2016/10/04 | Source: | Category: copy
Rating: |  Discuss |   Briefcase | 1,492 reads
<< Newer    Items 41 to 60 of 15151    Older >>