On a Cloud: Data Storage Techniques

Jef King
Jef King

Data Audit History There have been several times when I needed to ensure that we could understand the changes of data overtime. This is inline with the idea of never deleting data; however, in keeping a full audit history you can more deeply understand user behaviors. Or, if you need to have data retention for…

0

On a Cloud: Soft Delete & Data Architecture

Soft Delete This video is a quick overview on why it is important to implement soft deletes on your data. With data being the most tangible commodity a developer works with it makes sense to protect it. Data Architecture A beginners overview of some of my fundamentals that I use when looking at data storage….

0

Automate SSRS Report Generation using PowerShell

This blog post is tested on SQL Server 2014 and PowerShell V5. PowerShell has become more feature-rich in every version. We are now looking at PowerShell V5 (currently can be downloaded as part of Windows Management Framework v5 April 2015 Preview). The support landscape with SQL Server hasn’t changed much. There isn’t a drastic increase…


How to Steal the Microsoft API Prize at Hack the North

It’s dangerous to go alone, take this all-in-one guide to winning our hackathon API prize! Follow and reach out to Mansib (@gaessaki) on Twitter for more insights on how students are taking over the world, how the cloud is taking over the universe and to learn about Azure powered toaster drones. If you have any…

0

On a Cloud: Queues

In my first two videos I have presented a couple quick overviews of Queues and a very typical queuing pattern. Both videos tackle queuing from a generic perspective and you can apply these to almost any queuing technology available today.   Basic Overview I posted a quick video on when and how you use queues….

0

Python and Data : SQL Server as a data source for Python applications

This post will show you how to use Python to connect to a SQL Server database, save and retrieve data. I ( @HockeyGeekGirl ) recently recorded some courses with Christopher Harrison ( @GeekTrainer ) on Microsoft Virtual Academy about coding with Python. During that series of courses we explored several different data sources. Sometimes it…

1

Let us take you from complete beginner to professional web developer

It can be difficult to connect the dots from beginner programmer to understanding the architecture of a full fledged application. We’ve put together a learning path to try and help! This post shares a learning path that can help you go from beginner coder to creating the architecture of a professional web application. If you…

3

The Most Underrated Features of SQL Server 2014 — Part 3

Guest Post by SQL Server Certified Master Warner Chaves Hello everybody, my name is Warner Chaves, a SQL Server DBA for almost 10 years, MCM, and frequent community contributor. I currently work at Pythian and when speaking to many of our clients I frequently get asked to highlight for them some of the compelling reasons…


The Most Underrated Features of SQL Server 2014 — Part 2

Guest Post by SQL Server Certified Master Warner Chaves Hello everybody, my name is Warner Chaves, a SQL Server DBA for almost 10 years, MCM, and frequent community contributor. I currently work at Pythian and when speaking to many of our clients I frequently get asked to highlight for them some of the compelling reasons…


BREAKPOINT: Get Your Data On with SQL Server and Visual Studio

When data is transformed into information it becomes a powerful and actionable tool for decision-making. But data doesn’t exist in a vacuum. Some of the best SQL server tools for data development run within Visual Studio. Paul Laberge and Jonathan Rozenblit show you how to harness the power of SQL Server or Windows Azure SQL…