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 […]
SQL Server
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 Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Why do we do the Virtual Conferences?
While it may seem like an odd question, I actually do get asked this quite often. I mean, while we do work with some sponsors occasionally, the fact is that we’re so focused on the sessions. Not in an obnoxious “aren’t we grand for doing this” way, but in a community way. I really think that information, tips, things we […]
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 […]
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 Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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 […]
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 Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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 Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Useful Undocumented SQL Server 2016 DBCC Commands (Part 1)
Useful Undocumented SQL Server 2016 DBCC Commands (Part 1) 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 addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax: DBCC addinstance (objectname, instancename)...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
A Holistic View of Database Management System (DBMS) – Part 2
ARCHITECTURE The design of a Database Management System (DBMS) relies on its architecture. It can be centralized or else decentralized or hierarchical. The architecture of a Database Management System (DBMS) can be perceived as either one (1) tier or multi (N) tier. Multi (N) tier architecture distributes the full system into connected however independent multiple (n) modules, which can be...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here