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

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

SSRS - Report for Stored Procedure with Parameters

You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.  Read more...
By Shawn Melton 2014/11/04 | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 6,486 reads

Getting Data Into and Out of PowerShell Objects

You can execute PowerShell code that creates the data of an object, but there is no cmdlet to generate the 'object notation' code from an existing PowerShell object; until now, that is. Phil Factor also produces a ConvertTo-YAML function and explains how they both work, with illustrative code.  Read more...
By Additional Articles 2014/11/04 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 7,974 reads

Summit 2014

The PASS Summit is this week in Seattle, and Steve Jones has a few thoughts.  Read more...
By Steve Jones 2014/11/04 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 88 reads

A Fundamental Security Mistake

Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.  Read more...
By Steve Jones 2014/11/03 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 384 reads

Data Science for SQL Folks: Leveraging SQL and R

Learn about how to build value driven analytics with SQL Server and R.   Read more...
By Frank A. Banin 2014/11/03 | Source: | Category: sql and r
Rating: |  Discuss |   Briefcase | 7,093 reads

Normalizing Performance

Determining the best performance value you can get for your effort is not as straightforward as you might think.  Read more...
By Steve Jones 2014/11/03 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 157 reads

Red Gate Software to unveil Database Lifecycle Management at PASS Summit

PASS attendees will get the chance to learn about Database Lifecycle Management (DLM) straight from its chief proponent: Red Gate Software, the database and .NET tooling company.  Read more...
By Press Release 2014/11/03 | Source: Red-Gate | Category: dlm
Rating: |  Discuss |   Briefcase | 147 reads

Format Durations in SQL Server Analysis Services

I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, I’d like to show these durations formatted as time using the hh:mm:ss format. How can I do this in Analysis Services (SSAS)? - Koen Verbeeck responds.  Read more...
By Additional Articles 2014/11/03 | Source: | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 5,720 reads

ETL Performance Auditing - Part 1: Introduction to ETL Auditing

This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/10/31 (first published: 2012/06/05) | Source: | Category: etl performance
Rating: |  Discuss |   Briefcase | 15,952 reads

The Data Center that Exploded

A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!  Read more...
By Additional Articles 2014/10/31 | Source: SimpleTalk | Category: fun
Rating:  Rate this |   Briefcase | 8,877 reads

The Geek Costume

This Friday Steve Jones has another fun poll. A question on the geek costume that might excite you the most.  Read more...
By Steve Jones 2014/10/31 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Database Design Follies: NULL vs. NOT NULL

It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems more contentious than you expected it to be.  Read more...
By Edward Pollack 2014/10/30 | Source: | Category: null
Rating: |  Discuss |   Briefcase | 11,139 reads

Have You Been Hacked?

Security is a big deal, and Steve Jones wonders if most data professionals would be aware that they had been hacked.  Read more...
By Steve Jones 2014/10/30 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 144 reads

Does NoSQL = NoDBA?

There’s a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they can’t find a table. You may have heard it before, but it made Matt Hilbert sit down and ponder. What’s happening? Is there a division opening up between the newly fashionable NoSQL followers and DBAs? Matt enters the world of NoSQL to investigate.  Read more...
By Additional Articles 2014/10/30 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 9,341 reads

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/10/29 | Source: | Category: cluster
Rating: |  Discuss |   Briefcase | 2,769 reads

Automating Red Gate SQL Compare with MSSQL Server Agent

How to compare two databases and email the results to every one who needs to know  Read more...
By Neil Burton 2014/10/29 | Source: | Category: red gate
Rating: |  Discuss |   Briefcase | 1,047 reads

Stuck in a Rut

What do people do when their job doesn't require a lot of technical skills? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2014/10/29 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 146 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/10/29 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 38,041 reads

Triple Digits

Salaries for data professionals have risen quite a bit, according to the latest salary survey. That's good for those of us working with SQL Server.  Read more...
By Steve Jones 2014/10/28 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 213 reads

Data Mining Part 19: Excel and Data Mining, Samples, Queries

This lesson explains how to Clean Data, Explore Data, get Samples of Data, Classify and query a Data Mining Model.  Read more...
By Daniel Calbimonte 2014/10/28 | Source: | Category: excel
Rating: |  Discuss |   Briefcase | 4,686 reads
<< Newer    Items 61 to 80 of 13257    Older >>