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

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

SQL Server Reporting Services CountDistinct and Previous Functions

Scott Murray takes a look at what count function variations and related functions are available in SQL Server Reporting Services (SSRS).  Read more...
By Additional Articles 2016/05/06 | Source: | Category: ssrs
Rating:  Rate this |   Briefcase | 2,706 reads

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.  Read more...
By Ryan Loftin 2016/05/05 | Source: | Category: openjson
Rating: |  Discuss |   Briefcase | 1,628 reads

ASP.NET Core: A More Realistic Starter Kit

ASP.NET Core is a fascinating platform with many good ideas, but in its present form (RC1)there is a culture shock for experienced ASP.NET developers to experience the effort involved in porting a realistic application. There is an obvious advantage on being able to host an application on any web server, but is this enough to compensate for losing the convenience of an integrated pipeline?  Read more...
By Additional Articles 2016/05/05 | Source: SimpleTalk | Category:
Rating: (not yet rated)  Rate this |   Briefcase | 3,188 reads

Promoting Engineers

It seems that often we promote the best technical people into managerial positions, but is that a good idea? Steve Jones notes that a few people think this is a bad idea and there ought to be a technical career path for IT workers.  Read more...
By Steve Jones 2016/05/05 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 274 reads

What’s in a name?

When a business does not have an agreed set of definitions for their every day terms slow burning chaos ensues.  Read more...
By David Poole 2016/05/04 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads

Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining

In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.  Read more...
By Daniel Calbimonte 2016/05/04 | Source: | Category: data
Rating: |  Discuss |   Briefcase | 787 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2016/05/04 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 22,354 reads

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.  Read more...
By Additional Articles 2016/05/04 | Source: | Category: string_split
Rating: (not yet rated)  Rate this |   Briefcase | 3,386 reads

What Does a DBA Do?

Today we have a guest editorial from Andy Warren as Steve is away. Andy tries to define what a DBA really does in a way that might make sense to others.  Read more...
By Andy Warren 2016/05/03 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 192 reads

GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

Ability to enable Instant File Initialization during the installation of SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 1,081 reads

Execute Dynamic SQL commands in SQL Server

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?  Read more...
By Additional Articles 2016/05/03 | Source: | Category: dynamic sql
Rating:  Rate this |   Briefcase | 5,097 reads

Buzzword Bingo

What uses of acronyms and phrases hinder instead of help?  Read more...
By Gary Varga 2016/05/02 | Source: | Category: communication
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout

Your SQL Agent Jobs may be silently failing when using Linked Servers.  Read more...
By Chad Feghali 2016/05/02 | Source: | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,270 reads

Install Cumulative Updates

This week Steve Jones recommends installing Cumulative Updates. If you can test them.  Read more...
By Steve Jones 2016/05/02 | Source: | Category: patching
Rating: (not yet rated) |  Discuss |   Briefcase | 45 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/09 (first published: 2016/04/26) | Source: | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 7,336 reads

Getting started with Azure SQL Data Warehouse

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.  Read more...
By Additional Articles 2016/05/02 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,588 reads

Stress Testing

It seems that one area many DBAs don't have much knowledge in is testing hardware.   Read more...
By Steve Jones 2016/04/29 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

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: | Category: power view
Rating: |  Discuss |   Briefcase | 11,997 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: | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,922 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,953 reads
<< Newer    Items 61 to 80 of 14752    Older >>