Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

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

Automatic UNDO in Oracle

Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many UNDO segments to create at startup, and what is the underlying goal of the process? David Fitzjarrell investigates.  Read more...
By Additional Articles 2015/10/06 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 2,247 reads

Write Cleaner T-SQL Using Version Control

If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to write better, cleaner, more readable code.  Read more...
By Ed Elliott 2015/10/05 | Source: | Category: source control
Rating: |  Discuss |   Briefcase | 5,335 reads

Learning about FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.  Read more...
By Site Owners 2015/10/05 | Source: | Category: for json
Rating: |  Discuss |   Briefcase | 2,948 reads

What's a Code Smell?

Poor patterns and practices are code smells. Steve Jones notes we have plenty in T-SQL.  Read more...
By Steve Jones 2015/10/05 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 184 reads

Power Query Formula Language in Power BI Desktop

The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch. In this article, Rob Sheldon demonstrates how to use it in Power BI Desktop to extract data from its source, filter rows, specify the columns, clean the data, and create visualisations.  Read more...
By Additional Articles 2015/10/05 | Source: SimpleTalk | Category: power bi
Rating:  Rate this |   Briefcase | 1,959 reads

What Can You Do?

Security alerts and concerns are serious, but that doesn't mean that everyone will treat them that way.  Read more...
By Steve Jones 2015/10/05 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

SQL Server Stored Procedures and SET options

SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.  Read more...
By Nakul Vachhrajani 2015/10/02 (first published: 2013/08/29) | Source: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 14,539 reads

The Work of the Ancients

We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.  Read more...
By Steve Jones 2015/10/02 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads

How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.   Read more...
By Additional Articles 2015/10/02 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 5,580 reads

Navigating Hadoop Resources

Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.  Read more...
By Daniel Klionsky 2015/10/01 | Source: | Category: big data
Rating: |  Discuss |   Briefcase | 3,129 reads

Creating Dashboards for Mobile Devices with Datazen

In this fourth installment, Arshad Ali demonstrates creating filters, publishing dashboards to the Datazen server and creating drill-through dashboards.  Read more...
By Additional Articles 2015/10/01 | Source: Database Journal | Category: mobile dashboard
Rating: (not yet rated)  Rate this |   Briefcase | 2,614 reads

Have a Think

It's easy for most of us to get caught up in work and not stop to think about the larger picture, or the longer term. Steve Jones thinks you should make time for both of these.  Read more...
By Steve Jones 2015/10/01 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Stairway to MDX - Level 15: Basic Set Functions: The Tail() Function

Return, in order, a specified number of elements from the end of a set. SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Tail() function.  Read more...
By Bill Pearson 2015/09/30 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,558 reads

Byte Me: Error Trapping

Hitting a snag. 
By Bob Lang 2015/09/30 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 343 reads

Install SQL Server Management Studio with Web Installer without Internet Access

One of the new features of SQL Server 2016 is the introduction of a Web Installer for the client tools. In this article, Daniel Farina goes through the entire process of downloading and installing the client tools even on machines without internet access.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,845 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2015/09/29 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,480 reads

Are you a Data Scientist?

A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.  Read more...
By Steve Jones 2015/09/29 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 215 reads

A general way to maintain History tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2015/09/28 | Source: | Category: maintenance
Rating: |  Discuss |   Briefcase | 7,324 reads

Learning the Query Store

Links and references to understand what the Query Store is in SQL Server 2016.  Read more...
By Site Owners 2015/09/28 | Source: | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 2,119 reads
<< Newer    Items 21 to 40 of 14143    Older >>