SQL Server

Editorials SQL Server

Data Flow and Capacity… and Knowing All The Variables

Data sources are certainly something that should be on nearly everyone’s radar.  With more devices, more analysis and more utility coming from information than ever before, it’s pretty obvious that our pendulum associated with being a data professional will have yet more swings in the direction of managing performance as things expand. This post from was interesting as they tried […]

Pro Members SQL Server Standard Members

A Holistic View of Database Management System (DBMS) – Part 4

Entity or Real World Object The entity can be an actual world item, either moving or motionless, which can be effortlessly distinguishable. For an instance, in a college database, Students, Faculty, Classes, as well as Courses which are offered can be taken as the entities. Each of these entities has a number of column or attributes or properties which give...

This content is for Pro, Pro Member, Pro Member, 90 Days, Non-Recur, Standard, Standard Member and Standard Member, 90 Days, Non-Recur members only.
Log In Register
Administration Editorials Encryption/Data Security Ethics Security SQL Server

PowerBI, Using that Data, IoT and the Borg

Yesterday Ben posted about where, exactly, the responsibility for security lays.  Is it with the DBA?  The network team?  Is it with the person or team that could have prevented the latest breach?  It’s a great question.  Make sure you check out the post if you haven’t seen it yet.  (Here’s a link) As we continue this revolution into more […]

Pro Members SQL Server Standard Members

How to make accurate estimates in an Agile environment – Part 2

This is the second installment of a 3-Part article regarding a question from a busy SQA Huddle Lead professional: How can we create more accurate estimates in an Agile space? With all our analysts as beginner, in an Agile space, I don’t believe they have been exposed to any concept of "resource estimation" or "test execution rate", and therefore providing...

This content is for Pro, Pro Member, Pro Member, 90 Days, Non-Recur, Standard, Standard Member and Standard Member, 90 Days, Non-Recur members only.
Log In Register
Editorials Ethics SQL Server

Building Data Estates… and Your Legacy as Data Folk

I’ve been listening (and re-listening) to a number of MS Ignite presentations – I love getting insight into the direction, the goals and the overall vision that they present when they’re talking about big over-arching issues.  Things like “tweak this statement” fade away and we’re left with directional, vision-oriented things.  That’s the good stuff.  It’s in the one of the […]

Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2016 DBCC Commands (Part 2)

Useful Undocumented SQL Server 2016 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2016. 1. DBCC errorlog This DBCC command can be used to truncate the current SQL Server log. You can use this command when you rarely...

This content is for Pro, Pro Member, Pro Member, 90 Days, Non-Recur, Standard, Standard Member and Standard Member, 90 Days, Non-Recur members only.
Log In Register
Editorials Encryption/Data Security Security SQL Server

Security Ignorance is Bliss – But Not in a Good Way

I’ve been poking around more and more about security, about best practices and about data protection.  I have spent a good deal of time watching the tried and true “Securing Your SQL Server” type sessions and trying to understand what is critical and what you can do about it. Security expert Duncan McAlynn (LinkedIn) sent me over a great video […]

Pro Members SQL Server Standard Members

A Holistic View of Database Management System (DBMS) – Part 3

Relational Model The widespread data model in DATABASE MANAGEMENT SYSTEM (DBMS) is the Relational Model. It is mainly a scientific model than any other models. This particular model is based on first (1st) order predicate logic as well as describes a relation or table as an n-ary relation or table. The key highpoints of this relational model are: · Data...

This content is for Pro, Pro Member, Pro Member, 90 Days, Non-Recur, Standard, Standard Member and Standard Member, 90 Days, Non-Recur members only.
Log In Register
Pro Members SQL Server Standard Members

How to Make Accurate Estimates in an Agile Environment – Part 1

Part 1 Today’s question comes from a busy SQA Huddle Lead professional: How can we create more accurate estimates in an Agile space? With all our analysts as beginner, in an Agile space, I don’t believe they have been exposed to any concept of "resource estimation" or "test execution rate", and therefore providing a good baseline of "how many TCs...

This content is for Pro, Pro Member, Pro Member, 90 Days, Non-Recur, Standard, Standard Member and Standard Member, 90 Days, Non-Recur members only.
Log In Register