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…
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….
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…
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…
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….
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…
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…
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…
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…
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…
