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

Latest Blog Posts

Big Data architectures

Over the last few years I have been involved in reviewing the architectures of various companies that are building or have built big data solutions.  When I say “big data”, I’m referring to the incorporation of semi-structured data such as sensor data, device data, web logs, and social media.  The… Read more

0 comments, 212 reads

Posted in James Serra's Blog on 29 April 2016

Possible PARAMETER SNIFFING Scenario in SQL

When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to learn more. So the other day we had to brain storm on one of the similar issues where the database stored procedure was returning data quickly as compared to the…

Read more

0 comments, 407 reads

Posted in EVERYDAY MSBI/SQL CHALLENGES on 29 April 2016

A New Look & A New Direction - Syndication – WaterOx Consulting

You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you choose. You're on your own, and you know what you know. And you are the guy who'll decide where to go. - Dr. Seuss

The post A New Look &… Read more

10 comments, 101 reads

Posted in WaterOx SQL on 28 April 2016

Power BI Is Finally in the Azure Trust Center

With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review where we are today with Power BI security and compliance as it relates to various customer needs. I do a lot of work with financial, energy, and medical customers.… Read more

0 comments, 408 reads

Posted in DataOnWheels on 28 April 2016

April MVP – Chris Yates

The April MVP nomination is Chris Yates (B|T).

Chris is one of those individuals that always have a positive outlook on life which infectious.  He hails from Louisville, Kentucky and over the past year I’ve had the pleasure of really  getting to know him.   Chris has a serious passion about… Read more

1 comments, 116 reads

Posted in John Morehouse | Sqlrus.com on 28 April 2016

Dynamic Security in Power BI

In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you  can use this feature to implement dynamic security. In other words, the data being displayed depends on the user that’s viewing it. I will not talk… Read more

3 comments, 388 reads

Posted in Koen Verbeeck on 28 April 2016

New Pluralsight Course – Understanding and Using Essential Tools in Enterprise Linux 7

My new course “Understanding and Using Essential Tools in Enterprise Linux 7” in now available on Pluralsight here!

This course targets IT professionals that design and maintain RHEL based enterprises. It aligns with RHCSA and RHCE objectives and can be used by both the IT pro learning new skills… Read more

0 comments, 117 reads

Posted in Anthony Nocentino's Blog on 28 April 2016

Red Gate Dependency Tracker - Making Databases Into Moving Art

data structures are art

If anyone thinks that working with complex data structures is boring... I don't know what world they live in. The problem is often that sql tables and data structures are just script files and lists of tables in an object explorer.

However, once you crack open… Read more

0 comments, 75 reads

Posted in SQL Barbarian on 27 April 2016

PowerShell – SQL Databases Backup Status Report of Multiple Servers

 

This post is a requirement from one of my blog reader.

There are plenty of scripts available to get the backup status of the databases across multiple server. The  requirement is to read a server name and application names from an input file. The server name is used for… Read more

0 comments, 113 reads

Posted in PowerSQL By Prashanth Jayaram on 27 April 2016

Customizing Your Azure Portal

Not all of us are going to use Azure in the same way. That’s just common sense. Therefore, not all of us are going to want it to look the same. Here’s a default view of the portal for a login I created within my own domain:

You can contrast… Read more

0 comments, 407 reads

Posted in The Scary DBA on 27 April 2016

My Cable Modem Keeps Rebooting!

There are obviously quite a few things that could cause internet issues that are totally out of our control, but there are some things that we may be able to try to help ourselves. Face it, dealing with cable service calls is right up there with doing your taxes. If… Read more

0 comments, 82 reads

Posted in cjsommer.com on 27 April 2016

Certificates, Proxies and Jobs! Oh My!

Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need them to have specific file level permissions! What do I do! I know I need to run my job/job step as a specific AD/Windows user but I don’t see how… Read more

0 comments, 574 reads

Posted in SQLStudies on 27 April 2016

PolyBase: I now Pronounce you SQL and Hadoop

  Are you interested in Hadoop? With SQL Server 2016 just around the corner, a powerful new feature is being included called PolyBase.  To summarize what it is, just think about it as a marriage between SQL Server and Hadoop.  It is a way to store and query data on…

Read more

0 comments, 145 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 27 April 2016

Columnstore Index Enhancements in SQL Server 2016

One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they continue developing this technology and make it faster and faster.

In a nutshell, as oppose to what we’re used to today, a Columnstore index keeps our data at the column-level… Read more

0 comments, 447 reads

Posted in Matan Yungman on 27 April 2016

Power BI and the Bing Maps API

This week I was working on a project for a school up North. This customer wanted to use Power BI and map visualizations to view the locations of the various school buildings in the district. The problem for this very large school district was that they were missing the street… Read more

0 comments, 427 reads

Posted in SQL with Dustin Ryan on 26 April 2016

MongoDB : How to get Top, Bottom,Middle and Range of records

In MongoDB,the limit() method is used to limit the result set to be returned. You can also use this with various methods such as sort() and skip() for various combination of requirement.

The MS SQL equivalent is TOP function

>SELECT TOP 10 * FROM <TABLENAME>

Some examples are

Top ‘N’Record

Read more

0 comments, 406 reads

Posted in PowerSQL By Prashanth Jayaram on 26 April 2016

Upcoming conferences

It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing SQLBits, I’ll still be getting a chance to enjoy an English summer.

InsideSQL

The InsideSQL conference is a new conference organised by Neil Hambly. It’s a deep-dive conference, with longer… Read more

1 comments, 143 reads

Posted in SQL In The Wild on 26 April 2016

Interview with Warwick Rudd

 

Part of traveling to various events and being a part of the SQL Community means one can meet some pretty awesome professionals. I was fortunate enough to run into Warwick Rudd (B|T) at one of the PASS Summit events held in Seattle, and he definitely… Read more

0 comments, 101 reads

Posted in The SQL Professor on 26 April 2016

Strengthsfinder Results

I recently took the Strengthsfinder evaluation and thought I’d save the results here.

Read more

0 comments, 103 reads

Posted in SQLAndy on 26 April 2016

How to Recover Data From Corrupted Log File In SQL Server ?

Introduction

SQL Server is a database platform designed for providing large-scale transactions, e-commerce applications, data mining, etc. It is widely used on Business platforms for data analysis, data integration and processing components.

Structured Query Language (commonly known as SQL) is a programming language used for managing data held in relational… Read more

Older posts