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

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

Great Developers

A great developer is worth more than an average one, but how much more? Steve Jones has a few thoughts for you to think about.  Read more...
By Steve Jones 2016/05/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 557 reads

Connecting to SQL Data Warehouse

The most frustrating thing with any new system is often just working out how to connect to it. Oddly, you can’t use SSMS with SQL Data Warehouse, but it is fine with SSDT, SSIS, Power BI desktop, sqlcmd, BCP, and a range of Microsoft cloud services - there are PowerShell Cmdlets too. Rob Sheldon provides the details.  Read more...
By Additional Articles 2016/05/30 | Source: SimpleTalk | Category: sql data warehouse
Rating: (not yet rated)  Rate this |   Briefcase | 2,632 reads

Mentors and Professional Groups

By Phil Factor 2016/05/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 36 reads

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.  Read more...
By Gary Strange 2016/05/27 (first published: 2015/02/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,154 reads

Bias, the Serial Killer of Diversity

Today we have a guest editorial from Kellyn Pot'Vin that tackles the tough topic of diversity.  Read more...
By dbakevlar 2016/05/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 127 reads

Automatically Creating UML Database Diagrams for SQL Server

SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell. Phil Factor shows how.  Read more...
By Additional Articles 2016/05/27 | Source: SimpleTalk | Category: diagrams
Rating: (not yet rated)  Rate this |   Briefcase | 4,061 reads

Diagnosing parallelism-related latching

Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.   Read more...
By David Fundakowski 2016/05/26 | Source: SQLServerCentral.com | Category: parallelism
Rating: |  Discuss |   Briefcase | 1,471 reads

Should I Stay or Go?

Today we have a guest editorial from Andy Warren that looks at the decision to leave a job. Or not.  Read more...
By Andy Warren 2016/05/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

A tour through tool improvements in SQL Server 2016

Ayo Olubeko talks through the improvements being made to SQL Server tooling in 2016.  Read more...
By Additional Articles 2016/05/26 | Source: SQLCAT | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,057 reads

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 | 1,116 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 | 68,242 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 | 3,359 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,919 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 | 143 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 | 2,120 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 | 1,846 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 | 916 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 | 129 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 | 91 reads
<< Newer    Items 81 to 100 of 14835    Older >>