Top Tips and Tricks to organize your email and projects Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs create effective systems […]
SQL Server
Undocumented SQL Server 2014 extended stored procedures (Part 1)
Undocumented SQL Server 2014 extended stored procedures (Part 1) In this article, you can find the description of some useful undocumented SQL Server 2014 extended stored procedures. sp_MSgetversion This extended stored procedure can be used to get the current version of Microsoft SQL Server. Syntax: EXECUTE sp_MSgetversion For example, to get the current SQL Server version, you can run: EXEC […]
Inquiring Information By means of JOINs As Well As Sub — Queries Part — 4
Inquiring Information By means of JOINs As Well As Sub – Queries Part – 4 By Means Of Altered Judgment Operators At the time of making use of sub – queries, an individual can practice the >, ALL It depicts GREATER than the MAXIMUM data in the output list. The code is My_Column_Name > ALL ( 1 , 2 , […]
How do you market two services under one roof?
How do you market two services under one roof? Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs create effective systems so […]
Service Broker security
Service Broker security Author: Basit A. Farooq You can secure a dialog between two separate instances of SQL Server using Service Broker. You have three options to create a dialog: • Without security • Authenticates the destination server and encrypts the data • Provides mutual authentication and encrypts the data To allow for encrypted communication with a service on a […]
Troubleshooting SQL Server 2014 System Stored Procedures
Troubleshooting SQL Server 2014 System Stored Procedures If you have problems with SQL Server 2014 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many system stored procedures bugs were fixed in SQL Server 2014 service packs, you should install the latest SQL Server service pack. At the […]
Inquiring Information By means of JOINs As Well As Sub-Queries Part — 3
Inquiring Information By means of JOINs As Well As Sub – Queries Part – 3 By Means Of The IN and EXISTS Keywords The sub – query gives back the data which is to be castoff by means of the External Query. A sub – query can give back one (1) or numerous (N) data. Subjected to the necessity, an […]
Troubleshooting problems with locking in SQL Server 2014 (Part 2)
Troubleshooting problems with locking in SQL Server 2014 (Part 2) If you have problems with SQL Server 2014 locking, review this troubleshooting checklist to find potential solutions. 1. Encapsulate transactions within SQL Server stored procedures. This can reduce network traffic, because your client will send to server only the stored procedure name (perhaps with some parameters), and reduce the amount […]
Inquiring Information By means of JOINs As Well As Sub — Queries Part — 2
Inquiring Information By means of JOINs As Well As Sub – Queries Part – 2 By Means Of A Cross Join The Cross Join is also identified as Cartesian Product, among two (2) tables or relations links each and every row or tuple from one table or relation with each and every row or tuple of the table or relation. […]
Troubleshooting problems with locking in SQL Server 2014 (Part 1)
Troubleshooting problems with locking in SQL Server 2014 (Part 1) If you have problems with SQL Server 2014 locking, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many locking bugs were fixed in SQL Server 2014 service packs, you should install the latest SQL Server service pack. At the time […]