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

<< Newer    Items 81 to 100 of 14677    Older >>
 

Powershell To Get Active Directory Users And Groups into SQL!

Use Powershell to query AD for Users, Groups and GroupMembers  Read more...
By Lowell Izaguirre 2016/03/31 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 3,005 reads

Creating a Date Dimension in a Tabular Model

As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.  Read more...
By Additional Articles 2016/03/31 | Source: SimpleTalk | Category: tabular model
Rating:  Rate this |   Briefcase | 3,411 reads

Examining SQL Server 2016

Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.  Read more...
By Steve Jones 2016/03/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 213 reads

Whitepaper: Database deployments: Choosing a state-based or migrations-based approach

This whitepaper explores the differences between the approaches, state based or migrations based, and how Redgate tools can help.  Read more...
By Press Release 2016/03/31 (first published: 2016/03/24) | Source: Redgate | Category: redgate software
Rating: (not yet rated)  Rate this |   Briefcase | 5,859 reads

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.  Read more...
By Gregory Larsen 2016/03/30 (first published: 2015/01/28) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 16,696 reads

Getting started with the SSIS Script Task

The SSIS Script Task allows you to add functionality to your SSIS package that does not already exist with the other predefined tasks. In this article, Daniel Calbimonte looks at how to get started using the SSIS Script Task with a few examples.  Read more...
By Additional Articles 2016/03/30 | Source: MSSQLTips.com | Category: ssis
Rating:  Rate this |   Briefcase | 3,495 reads

Is PowerShell Intimidating?

Today we have a guest editorial from Andy Warren that asks if the rest of you are intimidated by PowerShell.  Read more...
By Andy Warren 2016/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 107 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2016/03/30 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 70,740 reads

Two Things I Would Change in SSISDB Setup

I suggest these two changes to the SSISDB setup to prevent issues down the road.  Read more...
By Ben Kubicek 2016/03/29 | Source: SQLServerCentral.com | Category: ssisdb
Rating: |  Discuss |   Briefcase | 2,397 reads

Examining SQL Server 2016

Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.  Read more...
By Steve Jones 2016/03/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 213 reads

Webinar - Redgate DLM Demo (with TFS, TFS Build & Microsoft Release Management)

Redgate’s Arneh Eskandari and Microsoft SQL Server MVP, Steve Jones, will show you how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes. Today 12noon EDT   Read more...
By Press Release 2016/03/29 | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,950 reads

Track Your Consultants

It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.  Read more...
By Steve Jones 2016/03/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 58 reads

Introduction to Protecting SQL Server with Azure Site Recovery

Microsoft cloud platform allows you to provide resiliency for your on-premises SQL Server deployments. Marcin Policht describes this functionality, available as part of the Azure Site Recovery solution.  Read more...
By Additional Articles 2016/03/29 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,617 reads

Trigger Happy

This article looks at using triggers to audit and to prevent the performing of unintended actions.  Read more...
By Andy Jones 2016/03/28 | Source: SQLServerCentral.com | Category: trigger
Rating: |  Discuss |   Briefcase | 2,745 reads

SQL Server Metadata Functions: The Basics

To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article.  Read more...
By Additional Articles 2016/03/28 | Source: SimpleTalk | Category: metadata functions
Rating: (not yet rated)  Rate this |   Briefcase | 6,302 reads

Dexterity Matters

The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.  Read more...
By Steve Jones 2016/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 58 reads

On formatting SQL code

How much SQL code formatting is too much?  Read more...
By Phil Factor 2016/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 122 reads

Why Every SQL Server Installation Should Be a Cluster

In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).  Read more...
By Francis Apel 2016/03/25 (first published: 2014/04/15) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 12,805 reads

Protecting sa

Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.  Read more...
By Steve Jones 2016/03/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

When AUTO_UPDATE_STATISTICS Doesn't Happen

When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the distribution statistics are out-of-date, they will be updated before the next query is executed against that index or table. Curiously, this isn't always the case. What actually happens is that the statistics only gets updated if needed by the query optimiser to determine an effective query plan.  Read more...
By Additional Articles 2016/03/25 | Source: SimpleTalk | Category: auto_update_statistics
Rating: (not yet rated)  Rate this |   Briefcase | 3,821 reads
<< Newer    Items 81 to 100 of 14677    Older >>