• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » Blog » SQL » Page 2

SQL

SQL stands for Structured Query Language and allows you to access and manipulate databases. SQL has many advantages which makes it a popular and efficient language for communicating with the databases such as faster query processing and easy to learn. Check the latest posts from tutorials to troubleshooting from Joe Gill.

Conditional Formatting in Reporting Services using Common Code

29th July 2009 by Joe Gill Leave a Comment

The lack of support for CSS style sheets in reporting services can make life difficult when you want to have common formatting across reports. There are also occasions where you may want to share common conditional formatting logic across reports. This example shows how common code can be used to help in these scenarios. Whilst a .NET assembly would probably be more efficient … [Read more...] about Conditional Formatting in Reporting Services using Common Code

Cork talk on using CLR inside SQL Server

6th April 2009 by Joe Gill Leave a Comment

PJ Naughter, a Microsoft MVP, is coming to Cork on April 27 to do a talk on using .NET Common Language Runtime (CLR) inside SQL Server.Register on the mtug web site register … [Read more...] about Cork talk on using CLR inside SQL Server

SQL Server Indexing Talk – Niall Flanagan

14th October 2008 by Joe Gill Leave a Comment

Niall Flanagan did a great talk to MTUG Cork on indexing and fragmentation in sql server last night. It was a good session and it went on for over two hours with lots of interaction.Well done NiallThe materials from the talk can be found on the materials tab on the event Event … [Read more...] about SQL Server Indexing Talk – Niall Flanagan

SQL Server Express Error 17053

1st September 2006 by Joe Gill Leave a Comment

Have not used express for a while and when I when to start the service I got an 17053 error saying could not open master.mdf, etc even though the files existSolution: Change the service to logon on as system account … [Read more...] about SQL Server Express Error 17053

Using Select into in Sql server

4th August 2006 by Joe Gill Leave a Comment

It's a No NoDon’t use select into as it locks the tempdb for the duration of the select. You have to create the temp table fist and then do a insert … select … from. Need to look at it this in SQL 2005. … [Read more...] about Using Select into in Sql server

« Previous Page

Primary Sidebar

Popular Categories

  • Power Platform
    • Power Apps
    • Power Automate
    • Power Virtual Agents
  • Azure
    • Logic Apps
  • Dynamics 365
  • .NET
  • AI
  • SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 By Joe Gill

Dataverse Anonymization

25th April 2022 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

Dataverse Metadata in Synapse

© 2022 · Joe Gill