-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2015

Notes From the September 16, 2015 Jacksonville SQL User Group Meeting

Forgot to post the next day and now missing details! Notes:

  • Rained the entire drive up (and back)
  • Not a bad drive for me, about 2 hours
  • You know it’s a strange day when you turn left at Wackos to get there
  • Location is a restaurant/bar/grill. Had to look twice,…

Read more

0 comments, 499 reads

Posted in SQLAndy on 30 September 2015

How to convert to Base64 and backwards via T-SQL

I want to share my way to convert a string to  Base64 and back. Let me note that presented method is not the fastest, but it has one important advantage – it works OOB, without CLR functions. We need a test database and a table to use as an example: Read more

0 comments, 1,236 reads

Posted in Forrards Group Database Blog on 30 September 2015

Deployment Contributor Logger

Niche tool of the day

If you know what a deployment contributor is and have wanted to see what steps were in a plan and have got bored setting a breakpoint in visual studio and using the watch window or something to display the steps in a plan, you might…

Read more

0 comments, 408 reads

Posted in Ed Elliott's Sql Developer Blog on 30 September 2015

SQL Data Generator–Masking Production Data

I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a good idea for masking some of that production data that you might not want developers to have.

Let’s start with a production table. In my case, I’ve created a Sandbox_Prod… Read more

2 comments, 3,126 reads

Posted in The Voice of the DBA on 30 September 2015

SQL Data Generator–Masking Production Data

I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a good idea for masking some of that production data that you might not want developers to have.

Let’s start with a production table. In my case, I’ve created a Sandbox_Prod… Read more

2 comments, 398 reads

Posted in The Voice of the DBA on 30 September 2015

Session Action Metadata

In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is a means to attach additional data from the stream to the event payload.

Recently, I have been covering various aspects of how to build an event session as well… Read more

2 comments, 526 reads

Posted in SQL RNNR on 30 September 2015

New SSRS features in SQL 2016 CTP 2.4

SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager at Microsoft because some of the MSDN documentation pages are already updated. One of those pages is What’s New in Reporting Services. There we can see three new features… Read more

0 comments, 1,574 reads

Posted in Koen Verbeeck on 30 September 2015

Updating a view

I was recently asked how to update views. Specifically the question was about using triggers to update a view.

So updating a simple view is easy enough. Per BOL:

Updatable Views
  • You can modify the data of an underlying base table through a view, as long as the following…

Read more

2 comments, 2,579 reads

Posted in SQLStudies on 30 September 2015

How to View and analyze SQLite Blob Data?

SQLite is one of the most commonly used database engine in the world. Its source code is available in public domain and which can be used for commercial or private purpose. Common data types used in SQLite are NULL, INTEGER, REAL, TEXT and BLOB. Unlike Blob, all other data types…

Read more

0 comments, 6,847 reads

Posted in Zora's SQL Tips on 30 September 2015

Utility link for excel import to SQL

Utility link for excel import to SQL

  • Save Excel Data into Databases

Connect to databases, edit data, and save changes back. Edit data using formulas and Search&Replace. Share data in your department using database tables instead of sharing or emailing workbooks. Share data among multiple worksheets and workbooks using embedded SQL Server…

Read more

0 comments, 27 reads

Posted in TSQL Circle Live on 30 September 2015

What’s happening in Asia Pacific?

G’day,

I really am going to make an effort to blog more, and this post is really the start of that.
I figure that I’ll just have to be more disciplined and set aside some time to complete a lot of posts that I’ve started, but remain in draft… Read more

0 comments, 525 reads

Posted in measure twice, cut once. on 30 September 2015

SQL Licensing

Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to upgrade to 2012/2014 from their old 2005 servers as they are going to be end of life in 2016. As the major confusion was the changes made in licensing from…

Read more

0 comments, 2,402 reads

Posted in on 30 September 2015

Bitwise XOR in DAX

In T-SQL and other languages we have bitwise XOR natively supported; the T-SQL operator is simply ^. Here’s the explanation of bitwise XOR for those not familiar:

https://en.wikipedia.org/wiki/Bitwise_operation

  1. Why would we want to implement this in DAX?
  2. How do we implement it?

1) I implemented XOR to ensure that only… Read more

0 comments, 1,768 reads

Posted in Jared Zagelbaum's Blog on 29 September 2015

Data Warehouse from the Ground Up at SQL Saturday Orlando, FL on Oct. 10th

SQL Saturday #442 is upon us and yours truly will be presenting in Orlando, Florida on October 10th alongside Mitchell Pearson (b|t). The session is scheduled at 10:35 AM and will last until 11:35 AM. I’m very excited to be presenting at SQL Saturday Orlando this… Read more

2 comments, 512 reads

Posted in SQL with Dustin Ryan on 29 September 2015

Azure Data Lake enhancements

I first blogged about Microsoft’s new product, the Azure Data Lake, a few months back (here).  There are already enhancements, as announced at Stata + Hadoop World.  Here they are in brief:

  • The Azure Data Lake has been renamed to the Azure Data Lake Store.  The…

Read more

2 comments, 605 reads

Posted in James Serra's Blog on 29 September 2015

Congrats to Jen, Tim, Ryan, and Argenis

Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford were re-elected to new terms. They’ve served for the past few years as members of the BOD. Ryan Adams was elected for the first time, and I supported his… Read more

0 comments, 520 reads

Posted in The Voice of the DBA on 29 September 2015

Congrats to Jen, Tim, Ryan, and Argenis

Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford were re-elected to new terms. They’ve served for the past few years as members of the BOD. Ryan Adams was elected for the first time, and I supported his… Read more

0 comments, 333 reads

Posted in The Voice of the DBA on 29 September 2015

Load Testing Your Storage Subsystem with Diskspd – Part II

In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to craft tests to measure bandwidth and latency for specific access patterns and IO sizes. In the last post “Load Testing Your Storage Subsystem with Diskspd”  we looked closely… Read more

2 comments, 4,467 reads

Posted in Anthony Nocentino's Blog on 29 September 2015

Do you write ugly T-SQL?

Are your scripts littered with commented blocks of T-SQL code?

select fname,lname 
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why this block is commented out
select fname,lname 
from usertable
where id=1
*/

Do you just start typing and rely on word wrap to fit your… Read more

10 comments, 5,715 reads

Posted in cjsommer.com on 29 September 2015

Calculate Percentage Share in Power BI (DAX)

What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI using DAX.

I’ll start with a table containing population by country as shown below. I’m using Power BI Desktop for this demonstration. You can use the same formula… Read more

7 comments, 8,673 reads

Posted in Sam Vanga on 29 September 2015

Older posts