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

   Items 1 to 20 of 14746    Older >>
 

Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI

In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers.  Read more...
By Erin Stellato 2016/05/25 | Source: SQLServerCentral.com | Category: extended events
Rating: |  Discuss |   Briefcase | 665 reads

Byte Me: Forget It

By Bob Lang 2016/05/25 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/05/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 66,549 reads

Implementing Azure SQL Database Elastic Database Jobs

Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'. In this article, David Fitzjarrell takes a look at one such example in action.  Read more...
By Additional Articles 2016/05/25 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 1,091 reads

How to deploy and execute an SSIS package from the SSISDB catalog

Beginning with SQL Server 2012, SQL Server Integration Services packages can be deployed and executed from a SQL Server database named SSISDB, which serves as a repository for SSIS packages.   Read more...
By Stan Kulp 2016/05/24 | Source: SQLServerCentral.com | Category: ssis package execution
Rating: |  Discuss |   Briefcase | 1,449 reads

The Clustered Index is not the Primary Key

As the title says, the clustered index doesn't have to the primary key and vice versa.  Read more...
By Steve Jones 2016/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 88 reads

Unified Approach to Generating Documentation for PowerShell Cmdlets

Now, it is easy to provide professional-quality documentation for PowerShell cmdlets, and to keep it in sync when you make changes, whether they are written in PowerShell or C#. While this has always been easy to do in PowerShell, it was always painful to do in C# or VB because it meant having to build your own MAML file. Michael Sorens completes his three-part series by summarising, in a wallchart, how to go about it.  Read more...
By Additional Articles 2016/05/24 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,075 reads

Inside-SQL Conference: SQL Server Deep Dives in London

14th June, Londo, UK - Inside-SQL conference offers deep dives on a range of SQL Server topics, with tracks focusing on DBAs, Developers and BI. Use the discount code "Redgate" for £40 off the price of a ticket.  Read more...
By Additional Articles 2016/05/24 | Category: inside-sql
Rating: (not yet rated)  Rate this |   Briefcase | 940 reads

Sharing on-premises SQL Server Data Analyses in the Cloud with Power BI

In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data  Read more...
By Adam Aspin 2016/05/23 | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 706 reads

The Politics of SQL Security

Dealing with SQL Server security when the application it uses is full of security holes.  Read more...
By Scott Crosby 2016/05/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 98 reads

Boundless Opportunities

There has never been more reasons or better opportunities to learn new skills. Gail Shaw shares her favorite online video training resources sites, what's on her current learning list and why.  Read more...
By Gail Shaw 2016/05/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 81 reads

Database Hardware and Infrastructure Trends

Glen Berry talks through a number of useful new developments in hardware, storage, and the Microsoft Windows and SQL Server ecosystem.  Read more...
By Additional Articles 2016/05/23 | Source: SQLPerformance.com | Category: hardware
Rating: (not yet rated)  Rate this |   Briefcase | 1,902 reads

Redgate DLM Demo (with TFS, TeamCity, Octopus Deploy)

How can Redgate DLM help you improve your database development and deployment processes? Join Grant Fritchey to see a demo of the Redgate DLM tools working with TFS, TeamCity, and Octopus Deploy. You'll learn how to version control your databases, include them in your CI process, and set up automated deployments. Register for the free webinar now.  Read more...
By 2016/05/23 (first published: 2016/05/19) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,284 reads

What's Your Test Plan?

This week Steve Jones looks at the formal way in which you might verify changes to your system. Do you have a process?  Read more...
By Steve Jones 2016/05/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Natively Compiled Stored Procedures: What they are all about

What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?  Read more...
By Edward Pollack 2016/05/20 (first published: 2014/08/04) | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 11,070 reads

Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys

Denzil Ribeiro looks at the validation phase of transaction lifetime.  Read more...
By Additional Articles 2016/05/20 | Source: Microsoft MSDN | Category: memory optimized tables
Rating: (not yet rated)  Rate this |   Briefcase | 1,284 reads

The Complexity of Branches

Branching code creates complexity to development and should be undertaken with caution.  Read more...
By Steve Jones 2016/05/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

A Comparison of JDBC Drivers for MySQL

A brief comparison of three different JDBC Drivers built for connecting with MySQL  Read more...
By Jerod Johnson 2016/05/19 | Source: SQLServerCentral.com | Category: jdbc
Rating: |  Discuss |   Briefcase | 707 reads

Comparing Networking Options in Azure

What are your options for connecting to an Azure VM? Sure, a Remote Desktop Protocol (RDP) connection will get you started but you'll soon need a full secure VPN connection. Azure can provide three different options for doing this: Point-to-Site (P2S), Site-to-Site (S2S), and ExpressRoute, but what are their relative advantages, and which one is right for the way you need to use Azure?  Read more...
By Additional Articles 2016/05/19 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,827 reads

Redgate DLM Demo (with TFS, TeamCity, Octopus Deploy)

How can Redgate DLM help you improve your database development and deployment processes? Join Grant Fritchey to see a demo of the Redgate DLM tools working with TFS, TeamCity, and Octopus Deploy. You'll learn how to version control your databases, include them in your CI process, and set up automated deployments. Register for the free webinar now.  Read more...
By 2016/05/23 (first published: 2016/05/19) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,284 reads
   Items 1 to 20 of 14746    Older >>