More CPU’s in SQL Server : Does it Help or Hurt? (MAXDOP): Common sense tells us , having more CPU’s mean more processing power , that means things would be done faster. Hold on for a sec..Its SQL Server. Common Sense isn’t applicable here. PUN …
Truncate Log – Rebuild Indexes – Statistics
Change FULL Recovery Model to SIMPLE and Shrink Log SELECT sys.databases.name , SUM(size) * 8 / 1024 AS [Total_disk_pace_MB] FROM sys.databases JOIN sys.master_files ON sys.databases.database_id = sys.master_files.database_id GROUP BY sys.databases.name ORDER BY 2 DESC , sys.databases.name; USE master; DECLARE @isql VARCHAR(2000) , @dbname VARCHAR(64) , …
Attaching Volume to EC2 Instance
Attaching Volume to EC2 Instance To list the partitions $ cat /proc/partitions major minor #blocks name 202 1 52428800 xvda1 Create a Volume in EC2 Instance and attach it to the instance. $ cat /proc/partitions major minor #blocks name 202 …
SQL Server or MySQL for our Business Needs?
Business Need: Currently we are in the cross-roads of growing from small-mid sized company to large scale K-12 online Test Delivery and reporting Solution provider. We primarily operate on K-12 Summative Market and its absolutely critical for us to provide 100 % accuracy and availability during Student Test windows. …
SQL Server 2014 – Memory Optimized Tables
Our Team Need : We have about 5-500 GB Databases and very few tables ( ~ About 10 tables ) are high volume high concurrency tables. At peak volume, we may write few thousands per second per table. We are in the business of providing …
SQL Server – Read Errorlog
Enable Audit log to capture successful and failed Logins — To Enable Failed and Successful Logins — Need to Restart the Server for this to effect EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’AuditLevel’, REG_DWORD, 3; GO — Query for Successful Logins EXEC sys.sp_readerrorlog @p1 = 0, — …
Useful Links and URLS
Useful Links and URLS Cassandra Calender: http://www.planetcassandra.org/Calendar Learn Ruby: Code Academy – http://www.codecademy.com/courses/ruby-beginner-en-d1Ylq/0/1?curriculum_id=5059f8619189a5000201fbcb Standford CS Courses: http://see.stanford.edu/see/lecturelist.aspx?coll=63480b48-8819-4efd-8412-263f1a472f5a MIT Open Courseware: http://ocw.mit.edu/courses/find-by-topic/ Khan Academy: https://www.khanacademy.org/ Java JDK Path: /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home David Malan Page: http://cs.harvard.edu/malan/courses/ SQL Server: Nested Loops Explained http://blogs.msdn.com/b/craigfr/archive/2006/07/26/679319.aspx Hash Join Explained http://blogs.msdn.com/b/craigfr/archive/2006/08/10/687630.aspx Merge …
NGINX and APACHE URL Redirects
NGINX APACHE URL Redirects Redirect all the requests to https server { listen 80; server_name i90runner.com; rewrite ^ https://$server_name$request_uri? permanent; } Redirect Specific Pages rewrite /humor /humor/humor.php; rewrite /events/search /Events/events_search.php; rewrite /events/summary /Events/events_summary.php; rewrite /photos /photos/index.php; rewrite /help /Technology/blog.php?ID=344; rewrite /hikes /Technology/blog.php?ID=386; Redirect based on …
Change HostName in Linux Machines
Change HostName in Linux Machines Edit /etc/hostname , make the name change, save the file. You should also make the same changes in /etc/hosts file Run sudo /etc/init.d/hostname restart or sudo service hostname restart /etc/hostname /etc/hosts sudo /etc/init.d/hostname restart sudo service hostname restart
Backup-Zip-Copy-Unzip-Restore-Notify SQL Server Databases
Backup-Zip-Copy-Unzip-Restore SQL Server Databases: I am sure we all try to bring databases from One Environment to Another Environment whether its to accomplish testing, debugging or maintaining the parity between production and lab. I used to spend little bit of time doing these tasks manually , after …