Posts

Image
SQL Window Functions    SQL window functions operate over a set of rows related to the current row within the result set. - Aggregate functions, return a single value for a group of rows, - Window functions return a single value for each row from the underlying query, based on the related set of rows. Lets say is a employees salaries table. - Simple SQL can return listing of employees ordered by salaries  - Using Aggregate like Sum can show total money paid as salary to all employess. - Adding group by to it can show salary total by department. - Using window functions can show number next to each employees  showing his rank. SQL window functions are also called OLAP (Online Analytical Processing) functions. Window functions are a subset of SQL functions that operate over a set (or "window") of rows related to the current row within the result set. Unlike aggregate functions, which return a single value for a group of rows, window functions return a single ...
Post a Comment
Read more
Image
  Azure Data Studio is a cross-platform client tool for developing code and managing databases on-premises and in the cloud. It was originally released as SQL Operations Studio. Azure Data Studio has edge over SQL Server Management Studio as it runs natively on Windows, Linux, and MacOS (yes windows tool on Mac too). https://www.sqlservercentral.com/articles/azure-data-studio-a-first-look?utm_source=sqlservercentral&utm_medium=email&utm_campaign=newsletter-1544&utm_term=advocates&utm_content=advocates Tips and Tricks https://community.thinkwisesoftware.com/news-blogs-21/switching-from-ssms-to-azure-data-studio-tips-tricks-4392
Post a Comment
Read more
Image
  SQL Dynamic Data Masking asking Dynamic Data Masking (DDM) is a new feature to the on-premise SQL Server instance beginning in SQL Server 2016. The purpose of DDM is to limit the ability of non privileged users to see certain information in a database. Administrative users can determine which fields are masked, and how they are masked, without requiring changes to application code. The masking is also consistently applied, no matter how the data is accessed. This is a feature that was first introduced in Azure SQL Database, where it received testing by users, and has migrated to the on-premise product. I would guess that many other new features will follow this path, and it is a good reason to keep an eye on the changes in Azure and test the features to understand how they may help you in the future when they are released on-premise. This article looks at how DDM works, how you can set it up, and manage permissions. Future articles will look in more depth at the way in which this...
Post a Comment
Read more

Azure AI Services

Image
  Azure Applied AI Services includes many tools below  - Vision Studio - Language Studio - Speech Studio - Azure Open AI Studio - Form Recognizer Studio Vision Studio This service can be used for the ability to read text, analyze images, and detect faces with technology like optical character recognition (OCR) and machine learning. The following are the capabilities of vision studio, namely, Video summary and frame locator-  Generate a summary of the main points in the video and locate specific keywords and jump to the relevant section, and it's still in the preview mode. Extract text from images-  Extract printed and handwritten style text from images and documents for supported languages. Search photos with natural language-  Retrieve specific moments within your photo album. For example, you can search for a birthday party you attended last month, your favorite places, or your pet or birds, and it's still in preview mode. Add captions to images-  Ge...
Post a Comment
Read more