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

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

Sweat Files and Practice Projects

Today we have a guest editorial from Andy Warren that looks at side projects and how you might actually grow our careers.  Read more...
By Andy Warren 2015/06/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 117 reads

A Syntax Mystery in a Previously Working Procedure

A previous working script show syntax errors on recreating (sp_helptext script line length limitation)  Read more...
By Marwa Joseph 2015/06/18 | Source: SQLServerCentral.com | Category: sp_helptext
Rating: |  Discuss |   Briefcase | 5,228 reads

Using R to Explore Data by Analysis - for SQL Professionals

What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with an interesting set of data, and some helpful suggestions that point out the parallels with SQL. Feodor provides the data and the helpful suggestions. The rest is up to you.  Read more...
By Additional Articles 2015/06/18 | Source: SimpleTalk | Category: r language
Rating: (not yet rated)  Rate this |   Briefcase | 3,956 reads

Culture Clashes and Arrogance

A guest editorial from Andy Warren looks at the disagreements between teams in technology.  Read more...
By Andy Warren 2015/06/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 163 reads

Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions

BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.  Read more...
By Bill Pearson 2015/06/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,518 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 2015/06/17 (first published: 2013/08/14) | Source: Redgate | Category: transaction logs
Rating:  Rate this |   Briefcase | 66,071 reads

Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell

In this article, Tim Smith goes through a couple of options to automate heartbeat checks against Azure databases. This is useful if you're moved SQL Server databases to Azure and you want to have periodic checks to make sure the databases are responsive.  Read more...
By Additional Articles 2015/06/17 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,319 reads

Data Mining Part 29: Programming with C# and AMO

In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.  Read more...
By Daniel Calbimonte 2015/06/16 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 1,960 reads

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.  Read more...
By Additional Articles 2015/06/16 | Source: Database Journal | Category: pivot
Rating:  Rate this |   Briefcase | 3,650 reads

More Regulation Coming?

With no end to company hack attacks in sight, will we get new regulation instead?  Read more...
By Steve Jones 2015/06/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 184 reads

How do you use change scripts for your database deployments?

Redgate is researching how people deploy their database changes. This is a very quick survey, and there's an opportunity to sign up for a research call in exchange for a $50 Amazon voucher.  Read more...
By Press Release 2015/06/16 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,391 reads

Five Minute Refactoring

The debate over how to change code or solve a problem can create arguments that last for years. Steve Jones notes the idea of limiting debates to five minutes is interesting.  Read more...
By Steve Jones 2015/06/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 150 reads

The Challenges of Space

CSS Engineers at Microsoft are reporting more space issues with database systems. Steve Jones has a few comments.  Read more...
By Steve Jones 2015/06/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 108 reads

Cellular Automation – SQL Server CPU, IO and Hekaton Stress Testing

This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.  Read more...
By Paul Brewer 2015/06/15 | Source: SQLServerCentral.com | Category: spatial
Rating: |  Discuss |   Briefcase | 2,911 reads

Powershell day-to-day Admin tasks: WMI, CIM and PSWA

WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.  Read more...
By Additional Articles 2015/06/15 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,453 reads

Stored Procedures and SQL Injection

Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.  Read more...
By Brian Kelley 2015/06/12 (first published: 2013/02/18) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 19,423 reads

The Rename Game

How often do you rename things? It seems to be more common for some than others.  Read more...
By Steve Jones 2015/06/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Managing Test Data as a Database CI Component - Part 2

Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.  Read more...
By Additional Articles 2015/06/12 | Source: SimpleTalk | Category: continuous integration
Rating: (not yet rated)  Rate this |   Briefcase | 2,346 reads

Checking Table Metadata with tSQLt

In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.  Read more...
By Steve Jones 2015/06/11 | Source: SQLServerCentral.com | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 4,155 reads

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.  Read more...
By Additional Articles 2015/06/11 | Source: Database Journal | Category: pivot
Rating:  Rate this |   Briefcase | 4,421 reads
<< Newer    Items 41 to 60 of 13862    Older >>