DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Curious about the future of data-driven systems? Join our Data Engineering roundtable and learn how to build scalable data platforms.

Data Engineering: The industry has come a long way from organizing unstructured data to adopting today's modern data pipelines. See how.

Threat Detection: Learn core practices for managing security risks and vulnerabilities in your organization — don't regret those threats!

Managing API integrations: Assess your use case and needs — plus learn patterns for the design, build, and maintenance of your integrations.

Avatar

Phil Factor

Writer at Simple Talk

Cambridge, GB

Joined Jul 2010

About

twitter: @Phil_Factor

Stats

Reputation: 1676
Pageviews: 508.9K
Articles: 9
Comments: 0
  • Articles

Articles

article thumbnail
Static Data and Database Builds
Whichever way you wish to ensure that a database, when built, has all the data that will enable it to function properly, there are reasonably simple ways of doing it.
June 14, 2019
· 8,707 Views · 1 Like
article thumbnail
Insert Statement Without Column List (BP004)
Explore a 'defense-in-depth' approach to writing SQL in order to avoid a problem when using INSERT code.
April 29, 2019
· 9,075 Views · 2 Likes
article thumbnail
Using a Variable-Length Datatype Without Explicit Length: The Whys and Wherefores (BP007/8)
Learn about built-in code analysis rules to warn you if you forget to specify string length both during variable-length string declaration (BP007) and coercion (BP008).
January 29, 2019
· 6,825 Views · 1 Like
article thumbnail
Monitoring Changes in Permissions, Users, Roles, and Logins
Let's take an in-depth look at monitoring changes in permissions, users, roles, and logins. Also explore SQL Monitor.
October 20, 2018
· 11,888 Views · 4 Likes
article thumbnail
How to Detect SQL Injection Attacks Using Extended Events and SQL Monitor
Want to learn more about how to detect an SQL Injection attack? Check out this post to learn how using Extended Events and the SQL Monitor.
September 14, 2018
· 13,017 Views · 3 Likes
article thumbnail
SQL Change Automation with PowerShell Scripts: Getting Up-and-Running
In this article, I'll demonstrate how to use SQL Change Automation to take the contents of a source control directory for a database, check that it is possible to build from it, document it, and then create a NuGet package.
July 5, 2018
· 9,728 Views · 1 Like
article thumbnail
Masking Data in Practice — Part 1
Read this article in order to learn about data masking, why to use it, what needs to be masked, and where masking takes place.
May 16, 2018
· 17,903 Views · 7 Likes
article thumbnail
Investigating Problems With Ad-Hoc Queries Using SQL Monitor
There are plenty of ways that apps can unintentionally misuse databases. When the abuses are pervasive, you can catch them by means of a few deft queries on various DMOs.
March 13, 2018
· 5,330 Views · 2 Likes
article thumbnail
Consider Using [NOT] EXISTS Instead of [NOT] IN
Which performs better for database query optimization: EXISTS, IN, ANY, EXCEPT, INNER JOIN, OUTER JOIN, or INTERSECT?
March 5, 2018
· 19,236 Views · 1 Like

User has been successfully modified

Failed to modify user

ABOUT US

  • About DZone
  • Support and feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends: