Keeping your FTP server organized can be a chore, especially if you frequently upload files. This blog post will guide you through creating a Python script that automates pushing files, keeps your “uploaded” folder clean, and removes any files older…
Data is vital for public safety agencies, helping them understand crime patterns and allocate resources effectively. This blog post will guide you through creating a Power BI dashboard to visualize call volume trends, focusing on day of the week and…
Need to integrate valuable information from XML files into your SQL Server database? SSIS offers a powerful solution! Here’s a simplified guide: 1. Build your SSIS package: Launch SSIS and create a new project. Drag and drop these components: XML…
Query Navigation and Editing: F5/Ctrl + E: Execute the current query. Ctrl + L: Clear the results pane. Ctrl + F5: Execute the current query and keep the results pane hidden. Alt + Break: Cancel a running query. Ctrl +…
Index fragmentation is when the data in an index is not stored in a continuous order. This can happen when data is added, deleted, or changed in a table. If an index is fragmented, it can take longer for SQL…
In this blog post, we will guide you through the process of creating a SQL user in Microsoft SQL Server using the graphical user interface (GUI) provided by SQL Server Management Studio (SSMS). The user will have access to only…
In the realm of public safety, the ability to share data effectively between various applications is crucial for streamlining operations and enhancing response times. JSON (JavaScript Object Notation), a lightweight and human-readable data interchange format, has emerged as a popular…
As developers, we often come across scenarios where different software applications need to communicate with each other, share data, or trigger specific actions. In this blog post, we will explore the process of creating a Windows application using C# that…
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SELECT ct.name as NatureOfCall, u.FirstName + ' ' + u.LastName as Employee, convert(date, (convert(datetime, switchoffset(c.CreateDatetime, datepart(tzoffset, c.CreateDatetime at time zone 'Central Standard Time'))))) as DateOfCall, convert(char(8), (convert(datetime, switchoffset(c.CreateDatetime, datepart(tzoffset, c.CreateDatetime at time zone 'Central Standard Time')))), 108) as TimeOfCall, a.HouseNumber + a.prefixdirectional + a.streetname + a.streettype + a.qualifier + ' / ' + a.xprefixdirectional + a.xstreetname + a.xstreettype + ', ' + a.city as AddressOfCall, c.CallNumber as CADNumber FROM [Call] c INNER JOIN Address a ON c.CurrentAddressID = a.AddressID INNER JOIN [CallType] ct on c.CallTypeID=ct.CallTypeID INNER JOIN Users u ON c.CreateUser = u.UserId WHERE c.CreateDatetime BETWEEN DATEADD(DAY, -1, GETDATE()) AND GETDATE() ORDER BY c.CreateDatetime FOR XML PATH('IncidentData'), ROOT('root') |
This is a SELECT statement in SQL that is used to retrieve data from multiple tables in a database. The statement begins by selecting a number of columns from the tables specified in the FROM clause. The first column…
Overview We can delete files older than X days. We can create a scheduled task to run the PowerShell script on a schedule. List Files To Delete
|
1 |
Get-ChildItem -Path "C:\SomePath\Folder" -Recurse -Force | Where-Object { !$_.PSIsContainer -and $_.Lastwritetime -lt (Get-Date).AddDays(-8) } |
This code uses the Get-ChildItem and Where-Object cmdlets to search for all…