SQL

Today, we’re going to dive into a topic that’s as exciting as building a world in Minecraft: keeping a database running smoothly. We’re going to discuss a concept called “index fragmentation” in SQL Server. Now, let’s think about Minecraft for a moment. When you start a new world, everything is organized and easy to navigate, …

Cisco has released updates to fix an improper user input validation vulnerability in Cisco Unified Communications Manager (Unified CM) and Cisco Unified Communications Manager Session Management Edition (Unified CM SME). The vulnerability could be exploited to conduct an SQL injection attack. Note While Cisco is not aware of this being exploited in the wild, it’s …

Question I am aware of the benefits of using partitioning and normalization strategies. Is breaking a database schema into smaller, more query-oriented tables a form of normalization? I have extensive experience in normalizing tables. Does normalizing tables affect query speed? Additionally, would a subsequent join have an effect on query performance? Furthermore, what can be …

Question I have been assigned the responsibility of enabling Windows Firewall on our server infrastructure. I have already configured the necessary rules for remote management and other essential services. However, since we are a development house with approximately 45 SQL servers, each of which use named instances which necessitates dynamic ports for connections, additional measures …

Question I require a date and time variable to be created where the date component is the current date and the time component is 8:00AM. Solution DECLARE @myDTvariable smalldatetime = DATEADD(HOUR, 8, CAST(CAST(GETDATE() AS date) AS smalldatetime))

Researchers from Claroty’s Team82 have “developed a generic bypass of industry-leading web application firewalls (WAF)… [that] involves appending JSON syntax to SQL injection payloads that a WAF is unable to parse.” The issue affects WAFs from Amazon Web Services, Cloudflare, F5, Imperva, and Palo Alto. All have updated their affected products to address the vulnerability. …

Problem Symptom If you ever need to use a different SQL Server Instance port for WSUS other than the default of 1433. This assumes you have already installed WSUS and configured it to work with an existing SQL Instance.

If an SQL injection attack is successful, it can lead to unauthorised access to the sensitive data of the targeted website’s browsers. The data which becomes accessible can include login details, financial details and other personal identifiable information. In some instances, the goal of the attacker(s) may be to gain a backdoor to the targeted …

Question I have a product table and I need to update the amount in the column table (float4 datatype) based on the increment percentage column. Example SQL command as below: The incrementPercentage column might have a value or it might be empty (null), I like to know if the UPDATE statement with a CASE statement …

Question We are re-visiting the topic of purchasing SQL Server 2019 Enterprise but are first configuring a Proof-of-Concept setup to get a feel of how well it works within our environment and how to migrate DBs to it. One thing we’re stuck on is that reading through the documentation it mentions Windows Server Failover Clustering …

Question If the Identity column is set to full specification and to increment on its own, how do I change the ID’s value for one of the records in Microsoft SQL Server 2012?

Question I am using Visual Studio 2017 Enterprise with GIT for source control and SQL Data Tools extension installed. I can see a lot of DTSX files, but when I try to open it, I can only see the XML. I am trying to see some automation and not see these DTSX files as XML. …

Question I have created a new job on my SQL Server by selecting an existing job, and selecting: Script Job as > Create To > New Query Editor Window Then I modified the name of the job in that script and executed it. But now the original and the new job seem to be tied …

Problem Symptom I get the below error when inserting data in the table with 1 primary key and 3 foreign keys, 1st row below is the Primary key index and I do not know the Partition. Why is this happening & How to fix this issue? The detailed error message is as below: ORA-01502: Index …

Question: Refer to the below SQL statement for syntax highlighted in bold. SELECT t1.* FROM provider_payments t1 WHERE t1.id = (SELECT MAX(t2.id)FROM provider_payments t2 WHERE t2.account_id = t1.account_id) Normally after the FROM clause, we would see “tablename1, tablename2”, but here we can not see a comma behind the table name. Read on below explanation to …