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

<< Newer    Items 21 to 40 of 15078    Older >>
 

Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions

Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.  Read more...
By Bill Pearson 2016/09/21 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 720 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2016/09/21 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 76,517 reads

Free-Con Pre-Con at the Pass Summit 2016

A free day of training on Monday, October 24 in Seattle this year. Join MCMs, MVPs, and Friends of Redgate for a free day of training.  Read more...
By Press Release 2016/09/21 | Source: SQLServerCentral.com | Category: conferences and events
Rating: (not yet rated)  Rate this |   Briefcase | 1,779 reads

Are You a Tech Company?

Is your company a tech company? Steve Jones looks at the world from the perspective of software development and how that impacts business.   Read more...
By Steve Jones 2016/09/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2016/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,988 reads

Reading the SQL Server log files using TSQL

The SQL Server Error Log is quite large and it's not always easy to view the contents with the Log File Viewer. Greg Robidoux presents an easy way to search and find errors using T-SQL.  Read more...
By Additional Articles 2016/09/20 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 4,413 reads

Free Webinar: Redgate DLM Demo

Learn how to use Redgate’s DLM solution to improve your database change management process in this free webinar on September 20th. Microsoft Data Platform MVPs, Steve Jones and Grant Fritchey, will demonstrate how Redgate’s tools plug into Visual Studio Online so that you can build, test and deploy your database alongside your application code. Register now.  Read more...
By 2016/09/20 (first published: 2016/09/15) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,094 reads

The Bones of SQL - The Holiday Table

This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.  Read more...
By Bob Hovious 2016/09/19 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 1,853 reads

The 10X Programmer

Today Steve Jones discusses the mythical 10x programmer from the context of databases.  Read more...
By Steve Jones 2016/09/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 115 reads

An Introduction to In-Memory OLTP Database Objects

In-memory OLTP was introduced in SQL Server 2014, but greatly improved in SQL Server 2016. If you have a heavily-used transaction-processing that is processing a lot of data, it is definitely worth considering the new 'In-Memory' features of SQL Server 2016. Grant Fritchey explains why.  Read more...
By Additional Articles 2016/09/19 | Source: SimpleTalk | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 3,528 reads

Why We Need Backups First

This week Steve Jones notes that backups aren't the most important thing for your data. Restores are.  Read more...
By Steve Jones 2016/09/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 86 reads

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?  Read more...
By Alessandro Mortola 2016/09/16 (first published: 2015/06/29) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 12,027 reads

The Danger of xp_cmdshell

This week Steve Jones wonders what you think of xp_cmdshell.  Read more...
By Steve Jones 2016/09/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 118 reads

Creating PowerShell Stacks and Expression Evaluators

To demonstrate that dynamic modules in PowerShell can be used to easily create objects with methods and properties, Phil Factor implements an expression analyser written in PowerShell, using a variation of Dijstra's Shunting Algorithm.  Read more...
By Additional Articles 2016/09/16 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,214 reads

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  Read more...
By Tomaž Kaštrun 2016/09/15 | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 1,838 reads

Data Science Education

Data Science is a hot area and one to which quite a few people would like to move. Steve Jones has some thoughts on trying to get certified in this area.  Read more...
By Steve Jones 2016/09/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 86 reads

Using SQL Compare with Row Level Security

Row Level Security is one of many new features in SQL Server 2016. It provides a much easier, consistent, and maintainable solution for row-based security rules. In this blog post, Data Platform MVP Steve Jones introduces this new feature, and walks through how Redgate SQL Compare can safely and reliably handle RLS changes.   Read more...
By Additional Articles 2016/09/15 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 2,449 reads

Free Webinar: Redgate DLM Demo

Learn how to use Redgate’s DLM solution to improve your database change management process in this free webinar on September 20th. Microsoft Data Platform MVPs, Steve Jones and Grant Fritchey, will demonstrate how Redgate’s tools plug into Visual Studio Online so that you can build, test and deploy your database alongside your application code. Register now.  Read more...
By 2016/09/20 (first published: 2016/09/15) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,094 reads

Stairway to U-SQL Level 8: Joining Tables in U-SQL

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.  Read more...
By Mike McQuillan 2016/09/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,375 reads

Down Tools Week 2016

Last week Steve Jones participated in the Down Tools Week at Redgate Software.  Read more...
By Steve Jones 2016/09/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads
<< Newer    Items 21 to 40 of 15078    Older >>