Tag Archives: SQL

Cannot connect to Microsoft SQL server after installing an IIS SSL Certificate

If you cannot connect to your Microsoft SQL Server after installing a web SSL Certificate, you may need to get the thumbprint of your certificate and copy it (without spaces) to your registry. Go to Hkey_Local_Machine\software\Microsoft\Microsoft SQL Server\{Find your instance … Continue reading

Rate this:

Posted in Technology, Windows Security, Windows Server | Tagged , , | Leave a comment

Slow SQL Connection or Network in Windows 10 – Update

Finally found a small problem with Windows 7, 8, 8.1 and 10.  After upgrading, we have discovered that Windows  was responding slow to our SQL Server 2008 and SQL Server / other versions.  What we discovered is below. Slow response … Continue reading

Rate this:

Posted in Information Technology, Microsoft, Microsoft Windows, Microsoft Windows 10, network, Networking, Technology, troubleshooting, Windows, Windows 10 Quick Tips, Windows Server | Tagged , , , | Leave a comment

Have a web server you’ve recently added a SSL certificate on and SQL is not starting?

Here’s a solution if you SQL isn’t starting –  SQL Dude’s Blog NARTAC also makes a software to help you tweak and strengthen ciphers and protocols.  IIS Crypto can be downloaded here. You can also test your site or other … Continue reading

Rate this:

Posted in Business, Computer Security, computer troubleshooting, Free Software, freeware, Information Technology, Technology, troubleshooting, Windows Security, Windows Server | Tagged , , , | Leave a comment

Slow SQL Connection or Network in Windows 10 – Update

Finally found a small problem with Windows 7, 8, 8.1 and 10.  After upgrading, we have discovered that Windows  was responding slow to our SQL Server 2008.  What we discovered is below. Slow response times in Windows to a SQL … Continue reading

Rate this:

Posted in Computer Security, Computers, freeware, Information Technology, network, Technology, Windows 10 Quick Tips, Wireless | Tagged , , , , , , , , , , , , , , , | 15 Comments

Improve SQL Network Performance

Need to improve your SQL Network Performance? Disable LLMNR – Clients and Server (Click enable) Adapter settings adjustment to match registry entry- RSS (below) Disable all but Flow Control and RSS settings – match registry entries for RSS Applies to both … Continue reading

Rate this:

Posted in Technology | Tagged , , , | Leave a comment

Connecting to SQL with Query Express

Once you get into IT and begin to mature, you’ll have dozens of paths to select.  One of the many things you may be asked to do is to query data.   While you can have direct access to the … Continue reading

Rate this:

Posted in Technology | Tagged , , | Leave a comment

Microsoft SQL slow after updates

While disabling LLMNR can speed up your SQL connection sometimes, ironically you may be slowed down by MS14-066 (KB2992611). See this article – “Microsoft does it again, botches KB 2992611 SChannel patch” – Infoworld What do you do?  The article above … Continue reading

Rate this:

Posted in Technology | Tagged , , , , | Leave a comment

Learn SQL Databasing

A few links to SQL tutorials – http://www.w3schools.com/sql/ http://www.sqlcourse.com/ http://www.1keydata.com/sql/sql.html http://sqlzoo.net/wiki/Main_Page

Rate this:

Posted in Technology | Tagged , , , | Leave a comment

Learn SQL with these Online Emulators

SQLCourse has been around for sometime.   With Microsoft’s DreamSpark, students can download SQL Server to build databases and to learn how to retrieve data by performing queries  (basically asking the database for specific data).   SQLCourse gives you step by step … Continue reading

Rate this:

Posted in Technology | Tagged , , , , , | Leave a comment

Cumulative update package 1 for SQL Server 2008 R2 Service Pack 2

Hotfixes for SQL after SP2.  A tiny 300+ mb download to fix several things after SP2. http://support.microsoft.com/kb/2720425

Rate this:

Posted in Technology | Tagged , , , , | Leave a comment

Enterprise computing is tough – Here’s some tips

Here’s a few tips we use when optimizing and troubleshooting computers and mobile devices on our network.   Remember Windows 8 is a different operating system and Windows Surface tablets can be a true productivity tool. Jumbo Frames – What … Continue reading

Rate this:

Posted in Computers | Tagged , , , , , , , , , , , , , , , , | Leave a comment

Expect A Surge In Breaches Following MySQL Vulnerability – Dark Reading

Vulnerability is so easily attacked and so prevalent that we’re bound for a bump in database exposures….Expect A Surge In Breaches Following MySQL Vulnerability – Dark Reading.

Rate this:

Posted in Computers | Tagged , , , , | Leave a comment

Mass SQL Injection Attack Hits 1 Million Sites – Dark Reading

A mass-injection attack similar to the highly publicized LizaMoon attacks this past spring has infected more than 1 million ASP.NET Web pages, Armorize researchers said today. According to database security experts, the SQL injection technique used in this attack depends … Continue reading

Rate this:

Posted in Computer Security, Computers, Hacking, Information Technology, network, Networking | Tagged , , , , , | Leave a comment

Monitor your servers and workstations with ManageEngine tools

ManageEngine has excellent software used to manage workstations, servers and other enterprise computing needs.   They also have some of the best software tools you can download and use for free. Their free  Windows Health Monitor Tool can be used : … Continue reading

Rate this:

Posted in Business, Computer Security, Computers, freeware, Information Technology, Internet, network, Software, Technology, Wireless | Tagged , , , , , , , , , , , | Leave a comment

SQL Videos

Microsoft offers free SQL Videos.  Link

Rate this:

Posted in Computers | Tagged , , , , | Leave a comment

Free SQL Server

Microsoft’s SQL Server Express 2008 R2 Edition is available for download.  SQL Server Express Edition works with PHP and includes a web interface.

Rate this:

Posted in Computers | Tagged , , , , | Leave a comment

Microsoft Learning Resources

It is amazing how many resources that are available on the web to learn Microsoft products.  Almost every career today requires computer skills.  Sign up for free learning. For Home Users- Tennnessee through June – Elevate America offers free learning … Continue reading

Rate this:

Posted in Computers | Tagged , , , , , , , , , | Leave a comment

SQL Server Native Client

You can download SQL Server 2008 Native Client here You can download SQL Server 2005 Native Client from here

Rate this:

Posted in Computers | Tagged , , , , , , | Leave a comment

Development for Beginners – Microsoft Programming

Microsoft has another excellent site to learn different skills used today.  Link

Rate this:

Posted in Computers | Tagged , , , , , , , , , , | 1 Comment

Free Programs from Microsoft

The express Editions from Microsoft allow you to learn the basics with: Visual Basic 2008 Visual Web Developer 2008 Visual C# 2008 Microsoft Web Platform  (SQL and loaded with other goodies!) Visual C++ 2008 Visual Studio

Rate this:

Posted in Computers | Tagged , , , , , , , , , , , , | Leave a comment