Standard Members

Editorials Pro Members Standard Members

Anemic Objects

Object Oriented Code has the distinction of consolidating both exposed properties and methods within a single object. Moreover, there may also be methods contained in that object, not exposed to the world. We seem to be moving away from that design. It would seem that in modern software development environments we have moved away from intelligent objects closer to what...

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
Already a member? Log in here
Editorials Pro Members Standard Members

Misleading Security Claims and Processes

I find myself shaking my head more and more about how things are rolling along with Security, and in particular (of course), data security. When I talk with people, and when you look at comments to posts on data breach articles, you see that so many don’t understand just how broad your data security and protection needs to be.  I’ve...

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
Already a member? Log in here
Editorials Pro Members Standard Members

The Version Advantage of SQL Azure

When it comes to keeping current with the capabilities of the SQL Server platform, SQL Azure has a bit of an advantage. If you are doing self hosted SQL Server on your own hardware or using Platform as a Service with your own SQL Server instances, then it is your responsibility to upgrade the version of SQL Server in use....

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
Already a member? Log in here
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 System Stored Procedures

Troubleshooting SQL Server 2016 System Stored Procedures If you have problems with SQL Server 2016 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many system stored procedures bugs were fixed in SQL Server 2016 service packs, you should install the latest SQL Server service pack. At the...

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
Already a member? Log in here
Editorials Pro Members Standard Members

Lets Get Some Passion

As I continue to interact with people working in IT I continue to be surprised at the number of people who are simply getting by. They have no passion for their chosen profession. Where do they fit into your organization? Sometimes it’s nice to have a software developer who learns a code pattern and can churn it out over and...

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, Standard Member Monthly - Fall Sale, and Free members only.
Register
Already a member? Log in here
Editorials Pro Members Standard Members

When You Need A Sandbox

There are times when you are making changes to your database, you need to isolate your work from other developers, and you don’t have resources to create a separate database from everyone else. Are there any options available to you? The easiest option in this scenario is to go back to the old school method of sharing the same database...

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
Already a member? Log in here
Pro Members SQL Server Standard Members

Switching Careers Gracefully

Today’s question comes from a busy professional: Life circumstances, interests, financial obligations, and the job market can all create the need to change careers multiple times throughout your life. What advice can you offer people who need or want to change careers? This could include tips on going back to school, leveraging your network in a new industry, writing a...

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
Already a member? Log in here
Pro Members SQL Server Standard Members

Troubleshooting problems with views in SQL Server 2016

Troubleshooting problems with views in SQL Server 2016 If you have problems with views in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many bugs with views in SQL Server 2016 were fixed in SQL Server service packs, you should install the latest SQL Server service pack....

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
Already a member? Log in here
Pro Members SQL Server Standard Members

Options we have for patching SQL Server Instances — (Part 1)

Author: Basit A. Masood-Al-Farooq In this first part of the two part article series, we will first explore the various SQL Server patch types. Next, we will explore the different options we have to patch SQL Server. Types of patches available for SQL Server The following are the main types of patches available for SQL Server: Service Packs A service...

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
Already a member? Log in here
Pro Members SQL Server Standard Members

Distributed Databases with Client Server Architectures Part – 7

An Outline of Client – Server (CS) Architecture As it was mentioned in the article introduction, full scale Distributed Database Management Systems (DDBMS) have not been advanced to support every category of functionalities which was discussed so far. As an alternative, distributed database applications are being established in the background of the client – server (CS) architectures. It is at...

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
Already a member? Log in here