Persistence of Vision

SHOWING SECONDS IN EXCEL DATE/TIME COLUMNS This is a very simple solution, but clearly it has been a long time since I posted. I was unable to post during the tenure at Nike. They are very�...

https://persistencevision.blogspot.com/2019/03/showing-seconds-in-excel-datetime.html

Just read this great post, Call me maybe: MongoDB and the wrap-up post, Call me maybe: final thoughts . They're part of a series called Jepsen  on behavior of various NoSQL databases in failur...

https://persistencevision.blogspot.com/2013/11/mongodb-and-cap.html

As I mentioned earlier , I signed up for "M102: MongoDB for DBAs ". Great class. I just completed it yesterday and got 100% on everything, homework and final. If you're interested in learnin...

https://persistencevision.blogspot.com/2013/11/completed-mongodb-m102.html

My boss, Ryan Smith, and I will co-present on modeling in NoSQL at Data Modeling Zone 2014 here in Portland. It's not until October of next year, so we don't have things nailed down yet, but i...

https://persistencevision.blogspot.com/2013/11/speaking-at-data-modeling-zone-2014.html

I was recently looking for reference material to back up my preference for storing date/time values in MongoDB in UTC using MongoDB's ISODate type. I found this great reference published at amazo...

https://persistencevision.blogspot.com/2013/11/restful-service-best-practices.html

SQL Server 2012 introduces sys.dm_exec_describe_first_result_set_for_object(). The official documentation is here . Let's work through some examples to discover what this new function delivers....

https://persistencevision.blogspot.com/2013/10/exploring-sql-server-2012s.html

I am in the middle of taking a free on-line class: "M102: MongoDB for DBAs ". Very interesting and educational so far. Also a bit frustrating. As I don't have a background in JavaScript, there ...

https://persistencevision.blogspot.com/2013/10/mongodb-training.html

My last day at Fiserv (second round) was Thursday, August 1st. On Monday, I started as an Expert Data Architect at Nike. I am so excited about this change and really look forward to what I...

https://persistencevision.blogspot.com/2013/08/just-do-it.html

My article on Hekaton: EXPLORING IN-MEMORY OLTP ENGINE (HEKATON) IN SQL SERVER 2014 CTP1 was published on Tuesday. This follows very closely the release of CTP1 of SQL Server 2014.

https://persistencevision.blogspot.com/2013/06/new-simple-talk-article-on-hekaton.html

CTP1 of SQL Server 2014 is now available! Go download it and start using it. My first SQL 2014 article will be published at simple-talk soon. I will update this post with a link once the artic...

https://persistencevision.blogspot.com/2013/06/sql-server-2014-ctp1.html

In addition to the Data Architect role that I will continue to play, I am now the Patterns and Practices Manager for the Digital Channels Enterprise Architecture team. Here is the text right o...

https://persistencevision.blogspot.com/2013/03/my-new-role-at-fiserv-patterns-and.html

I will be speaking to the Eugene Area SQL Server User Group on CDC. TOPIC: DECONSTRUCTING SQL SERVER'S CHANGE DATA CAPTURE SQL Server's Change Data Capture feature was introduced with SQL 2...

https://persistencevision.blogspot.com/2013/03/presenting-on-sql-server-change-data.html

I love to see a creative solution to a technical problem. HOW CAN I GET THAT USER OUT OF MY TABLE QUICKLY  by JackLi Great creative solution using indexed persisted computed columns. The be...

https://persistencevision.blogspot.com/2013/01/a-creative-use-of-computed-columns.html

Just finished reading this excellent article by Coda Hale: YOU CAN’T SACRIFICE PARTITION TOLERANCE I thought the bit about yield versus uptime was very interesting, as was the bit about h...

https://persistencevision.blogspot.com/2013/01/you-cant-sacrifice-partition-tolerance.html

My first sys.dm_db_stats_properties() post  showed results for SQL Server 2012 SP1. Here, I will show how the results for filtered indexes on 2008 R2 SP2 are different. The test script is exac...

https://persistencevision.blogspot.com/2012/12/sysdmdbstatsproperties-initial-results_20.html

The SQL Server team just released a new feature, the DMF sys.dm_db_stats_properties(). This new feature is available in 2008 R2 SP2 and 2012 SP1. These tests were run on SQL Server 2012 SP1 a...

https://persistencevision.blogspot.com/2012/12/sysdmdbstatsproperties-initial-results.html

I had been looking for a definitive statement on how TDE and compression work together. I found it here: Data Compression: Strategy, Capacity Planning and Best Practices > TDE encrypts the�...

https://persistencevision.blogspot.com/2012/11/sql-server-data-compression-and-tde.html

I had heard that SELECT INTO is faster than INSERT SELECT, so I wanted to prove it. Here are the results of testing in both FULL and SIMPLE recover models. Each test was run twice, once with IN...

https://persistencevision.blogspot.com/2012/08/select-into-is-faster-than-insert-select.html

Someone recently recommended that a developer use SQL Server's CDC (Change Data Capture) to create a history record for a transactional table because doing that work in a stored procedure "makes ...

https://persistencevision.blogspot.com/2012/08/sql-server-cdc-remember-its-not-free.html

I just attended the most intense and valuable week of training I have ever experienced: SQLskills' "IE1: Immersion Event on Internals and Performance ". This is a full week of training given by K...

https://persistencevision.blogspot.com/2012/08/sqlskills-ie1-immersion-event-on.html

When creating a computed column in SQL Server, be sure to use CONVERT (or CAST) to specify the datatype of the computed column, otherwise SQL Server will make the choice for you. It may not make ...

https://persistencevision.blogspot.com/2012/06/declare-datatype-when-creating-computed.html

To get a list of all columns in a database with "MAX" length, use this query: SELECT    SCHEMA_NAME(t.) + '.' + t.name + '.' + c.name    AS ,    TYPE_NAME(c.user_type_id)        ...

https://persistencevision.blogspot.com/2012/06/list-all-columns-with-max-length.html

Here is a table showing how many bytes each date/time datatype requires. The script to generate the table is after the table. TYPE BYTECT EXAMPLE PRECISION date 3 2012-06-08 smalld...

https://persistencevision.blogspot.com/2012/06/sql-server-datetime-byte-counts.html

SQL Fiddle is a new on-line tool that allows you to illustrate SQL DDL/DML. It currently defaults to SQL Server 2008 R2 but also supports 2012 and five other databases. Check out a simple exam...

https://persistencevision.blogspot.com/2012/05/sql-fiddle.html

I saw an interesting pattern in a Microsoft-supplied stored procedure today. They update a column and write a local variable at the same time. Here is an illustration of the technique. CODE: U...

https://persistencevision.blogspot.com/2012/04/update-column-and-simultaneously-set.html