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

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

Create stunning visualizations with Power View in 20 minutes or less!

Learn about Microsoft’s latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!  Read more...
By Amir Charania 2016/04/29 (first published: 2014/12/30) | Source: SQLServerCentral.com | Category: power view
Rating: |  Discuss |   Briefcase | 11,761 reads

Write for SQLServerCentral - Bonus for Azure

We're always looking for articles, but here are a few ones that I'd like to see written up.  Read more...
By Site Owners 2016/04/29 (first published: 2014/09/04) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,893 reads

Questions About PowerShell Basics That You Were Too Shy To Ask

Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.  Read more...
By Additional Articles 2016/04/29 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 3,159 reads

Generate a SSIS-package that reads from Twitter using Biml

Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter.  Read more...
Rating: |  Discuss |   Briefcase | 1,546 reads

Azure SQL Database Elastic Database Jobs

In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.  Read more...
By Additional Articles 2016/04/28 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,304 reads

Losing All Traces of Data

Could someone remove data from all systems and backups?  Read more...
By Steve Jones 2016/04/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 83 reads

Data Mining Part 38: Text Mining - The term lookup

In this new article, we will show how to use the SSIS term lookup transformation tool.   Read more...
By Daniel Calbimonte 2016/04/27 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,033 reads

Cloud First

SQL Server 2016 is the first cloud first version of SQL Server being released as the on-premise product.  Read more...
By Steve Jones 2016/04/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 65 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/04/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 78,632 reads

How to change server level collation for a SQL Server Instance

Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.  Read more...
By Additional Articles 2016/04/27 | Source: MSSQLTips.com | Category: server-level collation
Rating: (not yet rated)  Rate this |   Briefcase | 2,382 reads

SQL Server Resource Governor

Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.  Read more...
By Arun Sirpal 2016/04/26 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 1,320 reads

Specialist or Generalist

The idea of being a generalist of specialist may not need to be a choice.  Read more...
By Steve Jones 2016/04/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 98 reads

Announcing BIML Academy

Join Andy Leonard the week of May 9-13 for 5 free days of BIML training.   Read more...
By Press Release 2016/05/06 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 4,676 reads

The Practical Problems of Determining Equality and Equivalence in SQL

In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.  Read more...
By Additional Articles 2016/04/26 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 3,808 reads

The Pen Test

Perhaps a penetration test is a good idea for more organizations.  Read more...
By Steve Jones 2016/04/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 83 reads

Verify SQL Backups With SQL Powershell

With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.   Read more...
By Geoff Ruble 2016/04/25 | Source: SQLServerCentral.com | Category: sql backups
Rating: |  Discuss |   Briefcase | 1,870 reads

A nice whistle and flute

Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.  Read more...
By Phil Factor 2016/04/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 85 reads

Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables

Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.  Read more...
By Additional Articles 2016/04/25 | Source: SQLPerformance.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 4,975 reads

Write for SQLServerCentral - Bonus for Azure

We're always looking for articles, but here are a few ones that I'd like to see written up.  Read more...
By Site Owners 2016/04/29 (first published: 2014/09/04) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,893 reads

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.   Read more...
By Eirikur Eiriksson 2016/04/22 (first published: 2014/03/24) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 12,545 reads
<< Newer    Items 21 to 40 of 14695    Older >>