Stairway to ScriptDOM Level 3 - Finding Patterns in the Abstract Syntax Tree
Learn how you can query for patterns in the Abstract Syntax Tree to analyze your code.
2022-11-21 (first published: 2022-06-08)
1,066 reads
Code Analysis
Database Code Analysis
Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.
2017-08-18
3,546 reads
RE: Agile Development with Scrum
"The customer lists all the features they want in priority order."And how often can your customers tell you exactly what they want, let alone as a prioritized list?If you are lucky enough to get a feature list, and it doesn't change half-way through, everything will be top priority. If you make the decision for them, […]
2005-05-18
2005-05-11
Viewing Extended Properties in EM
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2005-04-18
RE: Using osql.exe cannot handle ascii extended characters
Hi Newbie, I have actually had an inverse of your experience where I have to use OSQL to handle our patch files that have extended ascii and Unicode characters. Could you post some sample data and a snippet of code that demonstrates your problem? -Jim
2005-04-14
RE: How to install service pack on sql server with multi-instances
There are different service packs for SQL (Standard and EE editions) than MSDE - you may need to download the MSDE SP3a and apply that.
2005-04-01
RE: SQL Agent won''''t start
Brian,Thanks for your help. I ran netstat -an, I did not see the sql server listening. Here is a view of the log file for the primary server:2005-03-16 09:36:35.62 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: […]
2005-03-16
latch timeout
Hi All, I am getting a latch (Type 4) timeout when accessing a certain page.CheckDB returns no errors and after truncating the table (Even dropping it) I still get the error.Trying to shrink the DB causes the error as well as all the backups.I got a log backup that runs once an hour and it's failing.Any […]
2005-03-08
3 reads
RE: Query Analyzer hosed
Just a thought. I've worked places where the system support staff would handle system updates, updates of common applications, and suchlike outside of normal working hours. Does your company do this? Could they have done this last night (even if they normally don't do it)? Do you have anything that processes updates/upgrades automatically (Windows Update […]
2005-02-23
Blogs
Daily Coping 8 Dec 2022
By Steve Jones
Today’s coping tip is to be curious. Learn about a new topic or an...
#PowershellBasics: Warnings and how to hide them.
One of my favorite parts of having a new job is that I learn...
Daily Coping 7 Dec 2022
By Steve Jones
Today’s coping tip is to stop for a minute when you walk outside and...
Forums
Problem Importing NULLs in varchar field
hello, This is something I'm really struggling with and haven't found much when I...
SQL Server 2022 is RTM
You can get your hands on SQL Server 2022 right now and this forum,...
Blocking
We were getting constant blocking on the db server. However, after stopping the process...
Ask SSC