Subscribe: SQLServerCentral.com Articles
http://www.sqlservercentral.com/sscrss.xml
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
code  data  database  explains  find  free  mode  new  procedure  server  services  show  sql code  sql server  sql  transaction 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: SQLServerCentral.com Articles

SQLServerCentral.com Articles



Articles posted on SQLServerCentral.com



 



Maintenance Routines for AlwaysOn

Mon, 05 Dec 2016 07:00:00 UT

How to determine what replica(s) to perform maintenance routines




Representing Hierarchical Data for Mere Mortals

Mon, 05 Dec 2016 07:00:00 UT

Why is it that we use XML, but with so little enthusiasm when it does so much, and is so feature-rich? Phil Factor argues that there are better ways of doing it, more complete than JSON, but easier to read than XML. To try to convince you, he gives a set of flying demos, using PowerShell and his PSYaml module, to illustrate how YAML can let you work faster, and more accurately.




Use SSMS and Visual Studio?

Mon, 05 Dec 2016 07:00:00 UT

Redgate is running a short survey to better understand the tools you're using for database development. There are eleven questions, and three $50 Amazon gift cards up for grabs as a thank you for responding.




Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT

Fri, 02 Dec 2016 07:00:00 UT

As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)




4 Keys to a Clean Angular Implementation

Fri, 02 Dec 2016 07:00:00 UT

Can there be true separation of concerns with MVC? Not entirely, especially when Angular's templates allow you to so much flexibility; but there is a great deal to be gained from following guidelines to ensure that all business logic is performed in the code-behind as directed by the controller or its delegate, and that all operations on the model are done in the controller: Michael Sorens explains the four essential guidelines for an easily-maintained system.




Have you adopted database DevOps?

Fri, 02 Dec 2016 07:00:00 UT

Redgate invites you to participate in a survey to uncover rates of adoption of DevOps practices among Microsoft SQL Server database users. The survey will take between 5 and 10 minutes to complete. All respondents who provide a valid email address will be sent a copy of the research report when available, as well as being entered into a prize draw to win a $250 Amazon gift card.




How to download a file from internet using SSIS

Thu, 01 Dec 2016 07:00:00 UT

In this example, we will show how to download a file from internet using SSIS.




A brief history of version control

Thu, 01 Dec 2016 07:00:00 UT

The fledgling computer industry did not invent version control. It merely adopted practices that were already well established in other industries. In part one of three, Wibke Carstensen takes a look at where it all started.




Script to find oldest open SQL Server transaction

Thu, 01 Dec 2016 07:00:00 UT

In this post, Eli Leiba shares a script that can be used to find the oldest open transaction and the statement that was issued.




SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed

Wed, 30 Nov 2016 07:00:00 UT

EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.




Free eBook: SQL Server Transaction Log Management

Wed, 30 Nov 2016 07:00:00 UT

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.




How to Get the Output of a Stored Procedure into a Table

Wed, 30 Nov 2016 07:00:00 UT

Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.




EzAdo Part 4

Tue, 29 Nov 2016 07:00:00 UT

EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.




Quick SQL Prompt Tip – using the CDB snippet

Tue, 29 Nov 2016 07:00:00 UT

There are a number of built-in snippets for SQL Prompt, and many of them are very simple, but they can greatly speed up your T-SQL coding if you learn what they are. Data Platform MVP Steve Jones shows how to make best use of the popular CDB snippet, for CREATE DATABASE statements, to save you time, but also ensure databases are created with the standard settings your organization may have, every time.




Who the Devil Wrote This SQL Code?

Tue, 29 Nov 2016 07:00:00 UT

The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out “Who the devil wrote this code?”, and then realise that it was you. Grant gives some examples of bad formatting and explains why you should never check-in badly-formatted SQL code.




How to Change an Analysis Services Instance to Tabular Mode

Mon, 28 Nov 2016 07:00:00 UT

In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode




Migrating Databases to Azure SQL Database

Mon, 28 Nov 2016 07:00:00 UT

Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database.




Experience SQL Server 2016 in Microsoft Luxembourg’s Intelligent Office

Mon, 28 Nov 2016 07:00:00 UT

The SQL Server Luxembourg User Group invites you to join us at our next event, in Microsoft’s new Intelligent Offices, for Tom van Zele’s SQL 2016 presentation. Tom’s road-show session highlights SQL Server 2016’s new features: End-to-end mobile BI, advanced analytics, cloud integration and lots of other new stuff will be addressed.




SQL in the City Streamed

Mon, 28 Nov 2016 07:00:00 UT

Register now for Redgate's free virtual event offering a wealth of SQL Server sessions for you to live-stream on December 14 and 15.




Top 5 things you MUST know about PowerPivot for Excel

Fri, 25 Nov 2016 07:00:00 UT

Although quite a lot has been written about PowerPivot and its features, there are certain aspects about PowerPivot that may not be obvious, especially to someone who is new to the tool. This articles discusses five such items.




What's New in SQL Server Reporting Services 2016

Fri, 25 Nov 2016 07:00:00 UT

Koen Verbeeck provides an overview of the new features and capabilities found in SQL Server Reporting Services 2016.




Change the Collation Setting for Clustered SQL Server 2014 Instance

Thu, 24 Nov 2016 07:00:00 UT

In this post I will show a procedure to change collation settings of SQL Server 2014 cluster instance.




5 Advantages of Load Balancing For IT Companies

Thu, 24 Nov 2016 07:00:00 UT

As an IT company, it is crucial that you maintain uptime and monitor the performance of various processes. By making database load balancing a key element, you can ensure that your processes and websites run smoothly. Tony Branson explains.




Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)

Wed, 23 Nov 2016 07:00:00 UT

In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.




Free eBook: SQL Server Internals: In-Memory OLTP

Wed, 23 Nov 2016 07:00:00 UT

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.




Which Edition of SQL Server is Best for Development Work?

Wed, 23 Nov 2016 07:00:00 UT

You might think, as a developer, that nothing but the best is good enough as a development database. You might be mistaken. There is a lot to be said for LocalDB, but Ed Elliott argues that every edition has its pros and cons, and you need to consider Cloud-based resources, VMs and Containerised databases too. There is a whole range of alternatives and how you choose depends on the type of database you are developing, but for Ed, LocalDB gets the five-star accolade.




Configuring Integration Services in a SQL Server 2016 Cluster

Tue, 22 Nov 2016 07:00:00 UT

In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.




Why Would I Ever Need to Partition My Big ‘Raw’ Data?

Tue, 22 Nov 2016 07:00:00 UT

Whether you are running an RDBMS, or a Big Data system, it is important to consider your data-partitioning strategy. As the volume of data grows, so it becomes increasingly important to match the way you partition your data to the way it is queried, to allow 'pruning' optimisation. When you have huge imports of data to consider, it can get complicated. Bartosz explains how to get things right; not perfect but wisely.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



SSC 2016 User Survey and Competition

Tue, 22 Nov 2016 07:00:00 UT

What do you want to see more of on SQL Server Central? Anything you think we should get rid of? Let us know in this 17-question user survey, and at the end you can choose to be entered into a draw to win a $100 Amazon gift card. Thanks to everyone who's already answered, we greatly appreciate the feedback!