JeySoftware

JeySoftware Making software affordable and helping your business grow. Specialized in software customization.Free consultation:1. Anytime via facebook2.

With appointment in-person

What’s So Bad About Shrinking Databases with DBCC SHRINKDATABASE?
13/11/2022

What’s So Bad About Shrinking Databases with DBCC SHRINKDATABASE?

You read a lot of advice that says you shouldn’t shrink databases, but…why? To demonstrate, I’m going to: Create a database Create a ~1GB table with 5M rows in it Put a clustered index on it, and check its fragmentation Look at my database’s empty space Shrink the database to get rid of the ...

My SQL Server database shows a very large size, but the sum size of all the tables is nowhere near the size of the datab...
13/11/2022

My SQL Server database shows a very large size, but the sum size of all the tables is nowhere near the size of the database. What should I do?

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

06/09/2020

Enabling Application Initialization in IIS - SQL Monitor 7 - Product Documentation

If you choose to use IIS to host the SQL Monitor web interface, and you wish to make use of the scheduled reporting feature to receive regular reports, then it will be necessary to enable the Application Initialization feature for IIS.

IIS 8.0 Asp.net warm up Auto Start & Application Initialization
06/09/2020

IIS 8.0 Asp.net warm up Auto Start & Application Initialization

Steps to setup IIS Asp.net Warmup module. Describe usage of Preload- System.Web.Hosting.IProcessHostPreloadClient

Use IIS Application Initialization for keeping ASP.NET Apps aliveEver want to run
06/09/2020

Use IIS Application Initialization for keeping ASP.NET Apps alive
Ever want to run

Ever want to run a service-like, always-on application inside of ASP.NET instead of creating a Windows Service or running a Console application? Need to make sure that your ASP.NET application is always running and comes up immediately after an Application Pool restart even if nobody hits your site?...

Multiple SQL Server instances with multiple fixed IP addresses on the same server
21/06/2020

Multiple SQL Server instances with multiple fixed IP addresses on the same server

Multiple SQl Server Instances on Same Server – Learn more on the SQLServerCentral forums

Designing matrix reports with RDLC
20/06/2020

Designing matrix reports with RDLC

A matrix aggregates data (such as SALES) along two or more dimensions (such as PRODUCT and SALESPERSON) and displays the results in a grid format. Matrices are similar to PivotTables in Excel, and crosstabs in Access.

SQL Server PIVOT
20/06/2020

SQL Server PIVOT

This tutorial shows you step by step how to use the SQL Server PIVOT operator to convert rows to columns.

How to encrypt SQL TDS connections
28/05/2020

How to encrypt SQL TDS connections

If your SQL clients (for example developers’ SQL Management Studios) and SQL Servers are not really “close” to each other, you should encrypt the tabular data stream (TDS) channel with SSL. First, …

Scheduled Tasks in ASP.NET
05/05/2020

Scheduled Tasks in ASP.NET

Explains how to simulate scheduled task using ASP.NET only, using Timer, Thread or Cache expiration.

Address

L1-OR-2, De Garden, No. 3, Persiaran Medan Ipoh
Ipoh
31400

Telephone

+60125881196

Website

Alerts

Be the first to know and let us send you an email when JeySoftware posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to JeySoftware:

Shortcuts

Share

Category